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 and 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 an IN clause or the sysams system catalog table does not 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 |