For a simplified processing of result tables, SQL-PL provides an extended FETCH statement. This statement, which can only be used in SQL-PL, serves to pass several rows of a result table into vectors with one call.
As in the case of the dynamic FETCH statement, it is also possible in the mass fetch statement to determine a named result table as well as the current rows.
Example:
The maximum number of rows to be read is determined by the smallest vector slice (here 20 rows). After the mass fetch has been executed, the $COUNT variable produces the number of results actually read.
The mass fetch statement can also be used after a dynamic SQL statement.
Syntax:
