Use this page to specify information for the SQLJ iterator declaration clause or the SQLJ assignment clause that you are creating.
An iterator is used to retrieve values from the result table from a query. An iterator is an object of an iterator class. An SQLJ file generates an iterator class for each iterator declaration clause that you specify. An iterator declaration clause declares a positioned iterator class or a named iterator class in an SQLJ file.
This page appears in the Insert SQLJ Iterator Declaration wizard and the Insert SQL Clause wizard.
If this check box is selected, the Update columns option is available.
If this check box is selected, the Sensitivity option is available.
The Dynamic option is available only when the sqlj.runtime.Scrollable check box is selected.
This attribute of the SQLJ WITH clause is available only when the sqlj.runtime.ForUpdate check box is selected.