A select-statement can be included as a part of the (nonexecutable) statement DECLARE CURSOR. Such a statement is executed every time the cursor is opened by means of the (embedded) statement OPEN. After the cursor is open, the result table can be retrieved one row at a time by successive executions of the FETCH statement or multiple rows at a time by using the multiple-row FETCH statement.
Used in this way, the select-statement can contain references to variables. These references are effectively replaced by the values that the variables have at the moment of executing OPEN.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.