The application programming interface (API) that the IBM Informix database server provides with the VTI consists primarily of the following components:
The Virtual-Table Interface (VTI) provides the following descriptors and accessor functions.
Descriptor | Describes | Accessor- Function Prefix | Reference |
---|---|---|---|
qualification descriptor
(MI_AM_QUAL_DESC) |
WHERE clause criteria | mi_qual_ | Qualification Descriptor |
row descriptor
(MI_ROW) |
Order and data types of projected columns | Various DataBlade API functions | IBM Informix: DataBlade API Programmer's Guide |
scan descriptor
(MI_AM_SCAN_DESC) |
SELECT clause projection | mi_scan_ | Scan Descriptor |
statistics descriptor
(MI_AM_TSTATS_DESC) |
Distribution of values | mi_tstats_ | Statistics Descriptor |
table descriptor
(MI_AM_TABLE_DESC) |
Table attributes and fragment partition | mi_tab_ | Table Descriptor |
Each of the following sections describes the contents of a descriptor and the name of the accessor function that retrieves each descriptor field. For complete syntax, including the parameters and return type of each accessor function, refer to Accessor Functions.