Table Procedure to DESCRIBE a SELECT

Document ID : KB000118793
Last Modified Date : 01/11/2018
Show Technical Document Details
This document contains a sample table procedure which can be used to "describe" the contents of an SQL select statement
The CA-IDMS/SQL option has no online DESCRIBE command.
However, the output of a dynamic PREPARE statement can be used to construct this information.
The table procedure in this document takes the output of such a statement and returns the attributes of each column in the select as a row of output.
This can be particularly useful for SQL against a network database where the attributes of the columns of a select statement may not be as readily obvious.
CA IDMS, all supported releases.
The source code and documentation for the table procedure is in the attached .zip file.
Additional Information:
Defining and Using Table Procedures
Data Types and Null Values
SQL Descriptor Area
File Attachments: