Describes the SELECT list or dynamic input variable specifications in a prepared statement into a descriptor area.
Information concerning the prepared statement identified by statement-name is placed in the named SQL descriptor area.
The two forms "DESCRIBE statement..." and "DESCRIBE OUTPUT statement..." are equivalent, and describe the items in the SELECT list of the statement into the SQL descriptor area.
The form "DESCRIBE INPUT statement..." describes the input variables of the statement into the SQL descriptor area.
If descriptions of both the SELECT list and the input variables are required for a prepared statement, the statement must be described separately with each form of DESCRIBE.
The descriptor-name is identified by a host variable or a literal.
See ALLOCATE DESCRIPTOR for a description of the SQL descriptor area.
See ALLOCATE CURSOR for a description of extended statements.
For a description of how to use the SQL descriptor area in dynamic application programs, see of the Mimer SQL Programmer's Manual.
The DESCRIBE statement is only applicable to dynamically prepared SQL statements.
YES Fully compliant.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40