Importing an SQL statement

Click Import Query to import an SQL statement. You can import an SQL statement either from the current session or from a personal library on the client workstation.

To save an SQL statement so that someone can later import it, start the SQL Wizard, create or open an SQL statement, run the SQL statement, go to the Results tab, and then click Save SQL. Use the Saved statements dialog to save the SQL statement to the current session or to a personal library.

When you import an SQL statement, the Macro Editor writes the contents of the imported SQL statement into the fields of the statement section. The Macro Editor also automatically formats the new information correctly for the underlying macro type (see The basic macro format versus the advanced macro format). Any already existing information in the fields of the statement section is overwritten.