SQL Editor
When you define Selection Criteria, the choices you make will automatically create the SQL required for selecting your data. The generated SQL is displayed in the SQL window of the Selection Criteria section of the Request. If, however, you want to create or edit the SQL yourself, rather than using the SQL automatically created by making selection criteria choices, you can click the Edit SQL icon (
) to open the SQL editor.
Important
If you manually edit and save your SQL, you can no longer go back and continue to use automated selection criteria. However, if you have not yet saved your manually created SQL, you can click the Undo SQL icon (
) and return to the Selection Criteria section of the Request.
If you are not already at the File-AID Data Editor Request for a DB2 Object dialog, see Opening-the-File-AID-Data-Editor and Accessing-DB2-Data for information on how to start the File-AID Data Editor.
To edit your SQL manually
1. Optionally, make any automated selection criteria choices as described in Edit DB2 Selection Criteria.
2. Click the Edit SQL icon (), then click Yes on the confirmation message. This opens the SQL Editor.
3. Enter your SQL as desired.
4. Optionally, click the Select Columns icon (
). The Select column dialog box appears. Select the desired column(s) and click OK. The selected columns are added to the SQL.
5. If you have not yet saved your edited SQL, you can click the Undo SQL icon (
) to discard your changes and return to the Selection Criteria section of the Request.
6. Optionally, to save your edited SQL, click Save. This will disable any further use of automated selection criteria for this saved Request.