Data Transformation Engine Services Guide

Chapter 22 – NonStop SQL/MP, NonStop SQL/MX, and ODBC Adapters
127
Generating Type Trees for NonStop SQL/MP,
NonStop SQL/MX and ODBC
You can generate type trees for queries, tables, and views in a NonStop SQL/MP or
NonStop SQL/MX and ODBC-compliant Relational Database Management System
(RDBMS) by using either of the following:
• Database Interface Designer
• mtsmaker with the Type Tree Maker (mtsmaker is a utility provided on non
Windows-based platforms to generate type trees)
For NonStop SQL/MP and NonStop SQL/MX, the Database Interface Designer and
mtsmaker get information about query columns, tables, or views by calling NonStop
SQL/MP or NonStop SQL/MX.
NonStop SQL/MP and NonStop SQL/MX return the data type, length, and other
information to the Database Interface Designer and mtsmaker.
For ODBC, the Database Interface Designer and mtsmaker get information about query
columns, tables, or views by calling the ODBC Driver Manager which, in turn, uses the
ODBC driver for the application RDBMS.
• The ODBC driver for the RDBMS maps the data types in each column to ODBC
data types as appropriate.
• From the RDBMS, the ODBC Driver Manager returns the ODBC data type,
length, and other information to the Database Interface Designer and mtsmaker.
The Database Interface Designer and mtsmaker then map the NonStop SQL/MP,
NonStop SQL/MX, or ODBC data types of the query columns, table, or view to item
types in a type tree.
Generating Type Trees With mtsmaker
1. Run the mtsmaker utility to create type tree script files (.mts) file for queries and
tables in SQL/MP, SQL/MX or ODBC-compliant Relational Database Management
Systems. (mtsmaker can also be used to generate type trees from a database query file
(.mdq).)
2. Transfer the type tree script files (.mts) from the NSK machine to the development
PC in BINARY mode.
3. On the development PC, use the Type Tree Maker to generate trees. (Type Tree
Maker is a facility for generating type trees from a script containing Type Tree
Maker commands (.mts file extension).)
The Type Tree Maker processes the type tree script and generates a type tree.
Generating Type Trees With the Database