am_insert

mi_integer 
am_insert(MI_AM_TABLE_DESC *tableDesc, 
   MI_ROW *row, mi_integer *rid)

tableDesc: points to the table descriptor.
row: points to a row structure in shared memory that contains the values for the access method to insert.
rid: points to the row identifier of the new row.

Possible row identifiers include:

The sequence of this row within the fragment
An offset to an LO handle
A value that an external data manager assigns
A value that the access method assigns

For each new entry, am_insert:

Restructures and converts the data in the MI_ROW data structure as necessary to conform to the source table
Stores the new data in the appropriate sbspace or extspace
If the data is in an extspace, the access method stores the rowID value for use in retrieving the new record in the future.

Important:

The database server does not call am_insert unless the am_readwrite purpose flag is set. If you do not set the am_rowids purpose flag, the database server ignores any row identifier that the access method provides. For more information about setting purpose flags, refer to SQL Statements for Access Methods.

Warning:

If the access method does not supply am_insert, but an SQL statement requires it, the database server raises an error. For more information on how to handle this error, refer to Supplying Error Messages and a User Guide.

MI_OK indicates success. MI_ERROR indicates failure.

See the descriptions of:

Purpose functions am_delete and am_update
Purpose flags am_readwrite and am_rowid in Settings Purpose Functions, Flags, and Values
Inserting, Deleting, and Updating Data

am_insert

Syntax

Usage

Return Values

Related Topics