DTLDESCRIBE retrieves the following types of metadata:

schemas, tables, and columns
procedures and procedure columns
records for non-relational databases
primary keys
foreign keys for relational databases

For non-relational data types, the Windows utility PWXUMAP can be deployed to execute DTLDESCRIBE SQL and store the results in a text file on the Windows system. For more information about the PWXUMAP utility, see the

PowerExchange Utilities Guide

.

For relational data types, the you can use the PowerExchange Navigator to run DTLDESCRIBE SQL in a row test. For more information about database row tests, see the

PowerExchange Navigator User Guide