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 a DB2® DBMS (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 get information about columns by calling DB2 to describe the columns associated with a query, table, view, or stored procedure. DB2 returns the data type, length, and other information to the Database Interface Designer and mtsmaker. The Database Interface Designer and mtsmaker then map the DB2 data types to types in a type tree.