DRAFT

Omnidex SQL: INSERT

Description

Inserts one or more records into a table and depending on the Omnidex index set up will automatically synchronize the Omnidex Indexes.

Syntax

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

  INSERT <table> SELECT <statement> 

Discussion

table_spec

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 - Specify options to be used for this command.

Examples

> INSERT INTO CUSTOMERS (COMPANY, CONTACT) VALUES ('DISC', 'JOHN DOE')
 
Back to top
dev/sql/statements/insert/home.txt ยท Last modified: 2016/06/28 22:38 (external edit)