Select existing SQL statement page

Use this page to select an existing SQL SELECT statement.

When you create an SQLJ file or SQL assignment clause, you can either select an existing SQL statement or use the wizard to create a new statement.

Use existing SQL statement

Inserts an existing SQL statement in the SQLJ file. If this check box is selected, select an SQL SELECT statement in the statement tree. If this check box is cleared, you can use the wizard to create a new SQL statement.

statement tree

Shows the projects and databases that contain SQL SELECT statements. To select an SQL statement, click the statement in the tree. To deselect the selected statement, press Ctrl+Spacebar.

SQL statement

Shows the code in the selected SQL statement.

Parent topic: Creating an SQLJ file

Related reference
SQLJ File page
Advanced Project Properties page
Specify Runtime Database Connection Information page

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

Related reference
Variables page
SQLJ Iterator Declaration page