Progress
SQL-92
Guide and Reference
DESCRIBE SELECT LIST Statement
Writes information about select list items in a prepared SELECT statement to an output SQLDA structure.
SYNTAX
statement_name
The name of a
SELECT
statement to be processed using dynamic SQL-92 steps. Typically, this is the same statement_name as in the PREPARE Statement.output_sqlda_name
The name of the SQLDA structure to which
DESCRIBE
will write information about select list items.NOTE: Select list items are column names and expressions in a SELECT Statement. A FETCH Statement writes the values returned by a SELECT Statement to the addresses stored in an output SQLDA.To utilize the DESCRIBE SELECT LIST statement in your application, issue statements in the following order:
A DESCRIBE SELECT LIST statement writes the number of select list items to the
sqld_nvars
field of an output SQLDA. If thesqld_size
field of the SQLDA is not equal to or greater than this number, DESCRIBE writes the value as a negative number tosqld_nvars
. Design your application to checksqld_nvars
for a negative number to determine if a particular output SQLDA is large enough to process the current SELECT Statement.AUTHORIZATION
None
SQL COMPLIANCE
SQL-92
ENVIRONMENT
Embedded SQL-92 only
RELATED STATEMENTS
PREPARE Statement, DECLARE CURSOR Statement, OPEN Statement, FETCH Statement, CLOSE Statement
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |