Database columns and types

The Database Interface Designer and mtsmaker with the Type Tree Maker generate type trees for queries, tables, views, and stored procedures in an Informix-compliant RDBMS (Relational Database Management System). Item types will be created in a type tree that represent the data types of the columns of a query, table, view, or stored procedure.

The Database Interface Designer and mtsmaker obtain information about columns by calling the Informix® Driver Manager that calls the Informix driver for your RDBMS to describe the columns associated with a query, table, view, or stored procedure. The Informix driver for the RDBMS has mapped the data types in each column to Informix data types as appropriate. From the RDBMS, the Informix Driver Manager returns the data type, length, and other information to the Database Interface Designer and mtsmaker. The Informix data types are then mapped to types in a type tree by the Database Interface Designer and mtsmaker.