Opening a DSQL Cursor
From InterBase
Go Up to Selecting Multiple Rows in DSQL
The OPEN
statement in DSQL establishes a results table from the input parameters specified in a previously declared and populated XSQLDA
. A cursor must be opened before data can be retrieved. The syntax for a DSQL OPEN
is:
OPEN cursorname USING DESCRIPTOR sqldaname;
For example, the following statement opens the cursor, C, using the XSQLDA
, InputSqlda
:
EXEC SQL OPEN C USING DESCRIPTOR InputSqlda;