Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


DESCRIBE


DESCRIBE gathers information on the result-set or dynamic variable specifications in a prepared statement and places the information in an SQL descriptor area.



Usage

Embedded.

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

Restrictions

The DESCRIBE statement is only applicable to dynamically prepared SQL statements.

Examples

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

Standard Compliance

Standard
Compliance
Comments
SQL-99
Features outside core
Feature B031, "Basic dynamic SQL".


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX