Progress
Embedded SQL-92
Guide and Reference
DESCRIBE BIND VARIABLES Statement
Specifies that the DESCRIBE statement should write information about any input variables in the prepared statement to an input SQLDA structure. Input variables represent values supplied to INSERT and UPDATE statements at run time, and to predicates in DELETE, UPDATE, and SELECT statements at run time.
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 reference entry for more information.
Design your program to issue a DESCRIBE BIND VARIABLES statement after a PREPARE statement, but before the corresponding EXECUTE or OPEN cursor statement for the SQL-92 statement.
This is the syntax for a DESCRIBE BIND VARIABLES statement:
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.
AUTHORIZATION
None
SQL COMPLIANCE
SQL-92
ENVIRONMENT
Embedded SQL-92 only
RELATED STATEMENTS
PREPARE Statement, DECLARE CURSOR Statement, OPEN Statement, FETCH Statement, CLOSE Statement, DESCRIBE SELECT LIST Statement
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |