Composing an SQL statement manually

Use the SQL Editor to manually define an SQL statement for a Select, Modify, or ProcedureCall bean. You also use the SQL Editor to edit an SQL statement that you previously created using the SQL Editor. (An SQL statement created with the SQL Assist SmartGuide is edited using the SQL Assist SmartGuide.) If you manually define an SQL statement, you may need to add meta-data information to the SQL specification generated in your database access class.


SQL Editor

As you compose your SQL statement, you can:

When you finish composing the SQL statement, select OK.

To cancel composing the SQL statement, select Cancel.