Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


DESCRIBE


Describes the SELECT list or dynamic input variable specifications in a prepared statement into a 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 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
X/Open-95
SQL92
YES
Fully compliant.



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