Use Setup/Cleanup
You use Setup/Cleanup in the Query Editor.
To use Setup/Cleanup
1. Click Edit, Setup/Cleanup.
Note: You can also access Setup/Cleanup by clicking Edit, Query, Setup/Cleanup in the Reporter.
The Setup/Cleanup dialog appears.
2. Type the desired SQL statements in either the Report Setup or Report Cleanup multiline entry fields.
3. Click Verify.
If there are errors, a Message pop-up appears, followed by an SQL Compilation Errors in User Code Editor, which lets you view the errors.
4. Click OK to close the editor.
5. After you have corrected any errors in the Setup/Cleanup dialog, click Execute only if you want the Setup or Cleanup statements to take effect immediately (which may be necessary if the report runs against temporary tables).
After you have defined the report, you can execute Cleanup to remove the temporary tables.
6. Click Save to save the Setup or Cleanup statements.
You are returned to the report document.