In some OLTP (On-Line Transaction Processing) applications,
like retail sales applications, where data is being added
to a database at a nearly constant rate, it may be more efficient
to separate the Omnidex index updates from the data updates,
eliminating the time it takes to update the indexes from the
total transaction time. The index updates can be performed
by a separate process using the INSERTINDEX, UPDATEINDEX,
and DELETEINDEX commands.
ODXAIM is an Omnidex utility that automatically updates the
Omnidex indexes using database triggers. It is the preferred
method to perform these types of updates when using the an
RDBMS to host an application. The INSERTINDEX, UDPATEINDEX,
and DELETEINDEX commands are provided for applications that
cannot make use of RDBMS triggers, for instance, flat file
database applications.
Syntax
INSERTINDEX INTO table [(column-list)] VALUES
(value-list) ROWID rowid [ON [INSTANCE] instance] [WITH options]
INSERTINDEX INTO
Required.
table
Required. The name of the table as defined in the Omnidex
environment catalog, that the indexes correspond to.
[(column-list)]
Optional. This is a comma-separated list of columns in the
table. This list must contain all MDK columns and all columns
that are part of a pseudo-column. If any of these columns
are omitted, an error will occur. The column list can contain
non-MDK columns and can contain a * to include all columns
in the table. Non-MDK columns will simply be ignored.
(value-list)
Required. This is a comma-separated list of values that are
to be inserted into the index files. The number of elements
in the value list must match the number of columns in the
column list. Values for non-MDK columns that were included
in the column list, can be blank.
ROWID rowid
Required. This is the ROWID (4-byte integer) of the new record.
If the table uses redefined rowids, this parameter must contain
the redefined rowid value.
[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 insertindex.
top
Example
Assume a record was inserted with the following SQL INSERT
INTO statement:
INSERT INTO CUSTOMERS (COMPANY, CONTACT, STATE)
VALUES ('Dynamic Information Systems Corporation','Dave Smith','CO')
The INSERTINDEX statement would look like the following:
INSERTINDEX INTO CUSTOMERS (COMPANY, CONTACT,
STATE) VALUES ('Dynamic Information Systems Corporation','Dave
Smith','CO') ROWID 1001
top
|