Table Descriptor

The table descriptor, or MI_AM_TABLE_DESC structure, provides information about the table, particularly the data definition from the CREATE TABLE statement that created the object.

The following accessor functions extract information from or set values in the table descriptor.

Accessor Function

Return Value

mi_tab_amparam()

Parameter values from the USING clause of the CREATE TABLE statement

mi_tab_createdate()

The date that the table was created

mi_tab_id()

The unique table identifier

mi_tab_isolevel()

The isolation level

mi_tab_istable()

MI_TRUE for a primary access method

mi_tab_mode()

The input/output mode (read-only, read and write, write-only, and log transactions)

mi_tab_name()

The table name

mi_tab_niorows()

The number of rows that mi_tab_setniorows() sets

mi_tab_numfrags()

The number of fragments in the table or 1 for a nonfragmented table

mi_tab_owner()

The table owner

mi_tab_partnum()

The unique partition number, or fragment identifier, of this table or fragment

mi_tab_rowdesc()

A pointer to a row descriptor that describes the columns in the row

mi_tab_spaceloc()

The extspace location of the table fragment

mi_tab_spacename()

The storage space name for the fragment from the CREATE TABLE statement IN clause

mi_tab_spacetype()

The type of space used for the table: X for an extspace or S for an sbspace

Any other value means that neither an IN clause nor the sysams system catalog table specifies the type of storage space.

mi_tab_update_stat_mode()

The level of statistics that an UPDATE STATISTICS statement generates: low, medium, or high

mi_tab_userdata()

A pointer to the user-data area of memory

The following accessor functions set values in the table descriptor.

Accessor Function

Value Set

mi_tab_setniorows()

The number of rows that shared memory can store from a scan

mi_tab_setnextrow()

One row of the number that mi_tab_setniorows() allows

mi_tab_setuserdata()

A pointer in the user-data area of memory