SQL Commands

INSERT

INSERT INTO table < [(column-list)] < VALUES (value-list) | select-stmt >> [ON [INSTANCE] instance] [WITH options]

Insert one or more records into a table.

INSERT INTO CUSTOMERS (COMPANY,CONTACT) VALUES ('DYNAMIC INFORMATION SYSTEMS CORP','DAVE SMITH')

Syntax

INSERT INTO table < [(column-list)] < VALUES (value-list) | select statement >> [ON [INSTANCE] instance] [WITH options]

INSERT INTO

Required.

table

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.

[(column-list)]

Optional if all columns are referenced in the value-list, otherwise required.

value-list | select statement

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.

[ON [INSTANCE] instance]

Optional. Specify the instance that this command will be executed on. If omitted, the current instance will be used.

[WITH options]

Optional. A comma separated list of options to use when performing this insert.

top

OdxSQL Example

top