Inserts one or more records into a table and depending on the Omnidex index set up will automatically synchronize the Omnidex Indexes.
INSERT INTO table_spec < [(column-list)] < VALUES (value-list) | select statement > > [ON [INSTANCE] instance] [WITH options] INSERT <table> SELECT <statement>
Required. The name of the table to insert data into, as defined in the Omnidex environment catalog or as assigned to a table created with the create table command.
Optional if all columns are referenced in the value-list, otherwise required.
Required. Specify a list of values to be inserted into the table or a select statement that will return the results to be inserted into the table.
Optional. Specify the instance that this command will be executed on. If omitted, the current instance will be used.
Optional - Specify options to be used for this command.
> INSERT INTO CUSTOMERS (COMPANY, CONTACT) VALUES ('DISC', 'JOHN DOE')