This is an old revision of the document!
INSERT INTO table < [(column-list)] < VALUES (value-list) | select statement >>
[ON [INSTANCE] instance]
[WITH options]
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')