Table Procedure to DESCRIBE a SELECT

Products

• IDMS
• IDMS - Database

Issue/Introduction

This document contains a sample table procedure which can be used to "describe" the contents of an SQL SELECT statement

The 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.

The document also includes a script to use the table procedure to list out the SQL attributes of all of the elements in the records of a network-defined schema pointed to by an SQL schema.

Environment

IDMS: all supported releases.

Resolution

The source code and documentation for the table procedure is in the attached .zip file.

Additional Information

Data Types and Null Values
SQL Descriptor Area