Table Procedure to DESCRIBE a SELECT

Document ID : KB000118793
Last Modified Date : 01/11/2018
Show Technical Document Details
Introduction:
This document contains a sample table procedure which can be used to "describe" the contents of an SQL select statement
Background:
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.
Environment:
CA IDMS, all supported releases.
Instructions:
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
DESCRIBE
File Attachments:
kb000118793.zip