Use the Review page to display the SQL statement that was generated from selections on the other pages. You can go to the Review page at any time to see the current state of your SQL statement. After you display the SQL statement, you can go to other pages in SQL Assist and change your selections. When you are satisfied with the SQL statement, you can go to the Review page and copy the statement to the clipboard, run it, or save it to a file.
Copying the SQL statement
To copy the SQL statement to the clipboard, select the portion of the SQL statement that you want to copy, then use Ctrl+C on your keyboard to copy the statement. You can then paste the SQL statement into other windows.
Editing the SQL statement
You can change any part of the SQL statement by selecting the appropriate page in SQL Assist and changing the selections on that page.
Depending on the application that you were using when you started SQL Assist, you might also be able to edit the statement by typing directly into the SQL statement field on the Review page.
If you manually edit the statement on the Review page, the other tabs are not available. You must click Undo to remove the changes that were made on the Review page and enable the tabs. When you click Undo, a confirmation window is displayed. Click OK in the confirmation window to remove the changes and enable the tabs. Click Cancel to keep the changes.
Saving the SQL statement
Click Save to save the SQL statement to a file. You cannot use SQL Assist to retrieve the saved file.
Testing the SQL statement
Click Run to run the SQL statement. The SQL statement runs on the database to which you are currently connected.
If the SQL statement contains a host variable, the Variable Values window is displayed when you run the statement. Use this window to enter a value for the specified host variable.
The result set is displayed in the Results window. From this window, you can:
Click Copy to clipboard to copy the result set to the clipboard.
Click Save results to save the result set to a file.
Related information
Specifying the tables for an SQL statement
Specifying search conditions for rows
Grouping rows and specifying search conditions for groups
Remapping data to another SQL data type