Opening a DSQL Cursor

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;