Structure arrays

You can use structure arrays for FETCH INTO statements that are non-dynamic, when you set the precompiler option COMPATIBILITY_MODE to ORA.

A structure array can be used to store multiple column data in a structure form when a FETCH INTO statement is run.

In one FETCH INTO statement, the maximum number of records that can be retrieved is the cardinality of the array that is declared. If more rows are available after the first fetch, you can repeat the FETCH INTO statement to obtain the next set of rows.

The total number of rows that are successfully fetched is stored in the sqlca.sqlerrd[2] field.

// Declare structure array with cardinality of 3.
EXEC SQL BEGIN DECLARE SECTION;
	struct MyStruct
	{
		int c1;
		char c2[11];
	} MyStructVar[3];
EXEC SQL DECLARE cur CURSOR FOR
	SELECT empno, lastname FROM employee;
EXEC SQL END DECLARE SECTION;
...
// MyStrutVar is a structure array for host variables
EXEC SQL FETCH cur INTO :MyStructVar;