Progress
SQL-92
Guide and Reference
DESCRIBE BIND VARIABLES Statement
Writes information about any input variables in the prepared statement to an input SQLDA structure.
SYNTAX
statement_name
The name of an input SQL-92 statement to be processed using dynamic SQL-92 steps. Typically, this is the same statement_name used in the
PREPARE
statement.input_sqlda_name
The name of the SQLDA structure to which
DESCRIBE
will write information about input variables. Input variables represent values supplied toINSERT
andUPDATE
statements at run time, and to predicates inDELETE
,UPDATE
, andSELECT
statements at run time.To utilize the DESCRIBE BIND VARIABLES statement in your application, issue statements in the following order:
The DESCRIBE BIND VARIABLES statement writes the number of input variables to the
sqld_nvars
field of the 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 SQLDA is large enough to process the current input statement.Input variables in dynamic SQL-92 statements are identified by parameter markers or as substitution names. See the PREPARE Statement for more information.
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 |