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 pageParent topic: Adding an SQLJ assignment clause to an SQLJ file
Related reference
Variables page
SQLJ Iterator Declaration page