Opening the SQL designer
For new queries
You can open the SQL designer to create a new query by using any of the following methods.
Menu: Choose File|Open (Alt+FNQ).
Navigator: Queries tab, double-click the Untitled icon.
Command window: Type
create query
To view or modify an existing query
You can open the SQL designer to load and review or modify an existing query by using any of the following methods.
Menu: Choose File|Open (Alt+FO or Ctrl+O) for the Open File dialog, then choose Queries from the Files of Type list, and locate your saved .SQL file.
Navigator: Queries tab, double-click the icon for an existing query file or select it and either press F2 or click the Design button on the toolbar.
Command window: Type
modify query <queryfile.sql>
where <queryfile.sql> is a saved query file. Note that if the file is not in the current directory (as shown in the Look In box in the Navigator), you must also include the full path to the file.