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;