The SQL Editor window displays the text of the currently open SQL statement in the SAM The text appears as you build or edit the statement using one of the following methods:
•Complete the statement construction dialog boxes.
•Import the statement from the clipboard or from a file.
•Type the statement in the SQL Editor window.
To see the entire text of longer SQL statements without scrolling horizontally, you can turn on word wrap in the SQL Editor window by selecting Options Ø Word wrap.
The SQL Editor window also contains push buttons located along the right-hand side. You can use these push buttons to help you edit and validate the SQL syntax of the statement currently displayed in the window.
The following table briefly describes these push buttons.
Select this push button ... |
To ... |
Cut |
Cut the text you highlight in the SQL Editor window and place it in the clipboard. |
Copy |
Copy the text you highlight in the SQL Editor window and place it in the clipboard. |
Paste |
Paste the contents of the clipboard into the SQL Editor window at the current cursor position |
Undo |
Delete the most recent text you added to the SQL Editor window. To reverse the last Undo operation and restore the statement to its previously saved state, select Undo again immediately. |
Validate |
Check whether the syntax of the current statement is valid according to UDB/DB2. |
Help |
Display online help for the DB/Assist Main Window. |
