Database columns and types

The Database Interface Designer and mtsmaker with the Type Tree Maker generate type trees for queries, tables, and views in a DB2-compliant Database Management System (DBMS). Item types are created in a type tree that represents the data types of the columns of a query, table, or view.

The Database Interface Designer and mtsmaker get information about columns by calling DB2® to describe the columns associated with a query, table, or view. 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.