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 the sqld_size field of the SQLDA is not equal to or greater than this number, DESCRIBE writes the value as a negative number to sqld_nvars. Design your application to check sqld_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

EXEC SQL
  DESCRIBE BIND VARIABLES FOR statement_name  INTO input_sqlda_name ; 

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