Fetching Rows with a DSQL Cursor
From InterBase
Go Up to Selecting Multiple Rows in DSQL
DSQL uses the FETCH
statement to retrieve rows from a results table. The rows are retrieved according to specifications provided in a previously established and populated extended SQL descriptor area (XSQLDA
) that describes the user’s request. The syntax for the DSQL FETCH
statement is:
FETCH cursorname USING DESCRIPTOR descriptorname;
For example, the following C code fragment declares XSQLDA
structures for input and output, and illustrates how the output structure is used in a FETCH
statement:
. . . XSQLDA *InputSqlda, *OutputSqlda; . . . EXEC SQL FETCH C USING DESCRIPTOR OutputSqlda; . . .
For more information about creating and filling XSQLDA
structures, and preparing DSQL queries with PREPARE
, see Using Dynamic SQL.