Variables page

Use this page to specify the names of variables to use in the SQLJ clause.

Specify optional contexts for SQL statement

Connection context instance

The name of the instance of a connection context class to use to define the database connection.

Execution context instance

The name of the instance of the sqlj.runtime.ExecutionContext class to use in the SQLJ executable statement.

Specify iterator for SQL statement

Iterator instance name

The name of the instance of an iterator class to use in the SQL SELECT statement.

Generate iterator instance declaration

Declares a variable to contain an instance of either an existing iterator class or a new iterator class that is generated with the wizard.

Use existing iterator class

Uses an existing iterator class to declare the variable for the instance.

Iterator class name

The name of the iterator class for which to declare a variable that contains the instance.

Generate new class iterator class declaration

Defines a new external iterator class and then creates a variable that contains an instance of the class.

Generate new inner class iterator class declaration

Defines a new inner iterator class and then creates a variable that contains an instance of the class.

Parent topic: Adding an SQLJ assignment clause to an SQLJ file

Related reference
Select existing SQL statement page
SQLJ Iterator Declaration page