DESCRIBE gathers information on the result-set or dynamic variable specifications in a prepared statement and places the information in an SQL 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 gather information on the items in the result-set of the statement and places it in the SQL descriptor area.
DESCRIBE INPUT statement... describes the statement's input and output variables.
DESCRIBE OUTPUT statement... describes the result-set returned by the statement.
If descriptions of both the result-set 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.
See also, GET DESCRIPTOR.
The DESCRIBE statement is only applicable to dynamically prepared SQL statements.
ExamplesEXEC SQL DESCRIBE OUTPUT stmt2 USING SQL DESCRIPTOR :SQLA1; EXEC SQL DESCRIBE INPUT 'stmt X1' USING SQL DESCRIPTOR 'DescrIn';
For more information, see the Mimer SQL Programmer's Manual, Describing Prepared Statements.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40