|
|
|
|
|
|
DESCRIBE
Describes the SELECT list or dynamic input variable specifications in a prepared statement into a descriptor area.
Usage
Description
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.
Restrictions
The DESCRIBE statement is only applicable to dynamically prepared SQL statements.
Standard Compliance
Standard
Compliance
Comments
SQL92
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|
