Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


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 statement_name USING SQL DESCRIPTOR :SQLA1;
 
 EXEC SQL DESCRIBE INPUT statement_name USING SQL DESCRIPTOR 'SQLA2';
 

For more information, see the Mimer SQL Programmer's Manual, chapter 11, Describing Prepared Statements.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
YES
Fully compliant.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX