mi_integer am_create(MI_AM_TABLE_DESC *tableDesc)

tableDesc

points to the index descriptor.

Even if the access method does not provide an am_create function, the database server automatically adds the created object to the system catalog tables, such as systablessysindexes. For example, a user might issue the CREATE INDEX command to register an existing, external index in the database server system catalog.

The am_create function typically:

• Calls accessor functions to extract index specifications from the table descriptor, including a pointer to the row descriptor
• Calls DataBlade API functions to extract column attributes from the row descriptor
• Verifies that the access method can provide all the requirements that the CREATE INDEX specifies
• Validates CREATE INDEX statements that specify identical keys, as described in Enabling Alternative Indexes
• Calls the appropriate DataBlade API functions to create a smart large object or interact with the operating system for file creation, as described in Managing Storage Spaces
• Executes support functions that build the index

  The access method might supply the support functions or execute UDRs from outside the access-method shared-object library. For more information, refer to Using FastPath.

MI_OK indicates success. MI_ERROR indicates failure.

In this manual, see the description of:

• Purpose function am_drop
• Creating and Dropping Database Objects

In the IBM Informix: DataBlade API Programmer's Guide, see the descriptions of:

• DataBlade API functions, such as mi_lo_create(), and create-time constants
• DataBlade API accessor functions for the row descriptor