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.

As you compose your SQL statement, you can:
- Cut text from the SQL statement. Select the text in the SQL Editor and select the Ctlr+X
keys on the keyboard. This copies the selected text to the clipboard. The cut text is
available for pasting.
- Copy text from the SQL statement to the clipboard. Select the text in the SQL Editor and
select the Ctrl+C keys on the keyboard. The copied text is available for pasting.
- Paste text from the clipboard into the SQL statement. Select the Ctlr+V keys on
the keyboard. This pastes the text at the position of the cursor.
- Delete text from the SQL statement. Select the text in the SQL Editor and select the Delete
or the Backspace key on the keyboard.
When you finish composing the SQL statement, select OK.
To cancel composing the SQL statement, select Cancel.
