- Click
. - Click Query.
- Type a File name for the exported emulation information.By default, the File Name box displays the name of the target system specified when connecting. See Connect to the Database.
- Specify a path to the folder in which to save the file.
- Click OK.
- Define the default database for running queries by doing one of the following:
- Type the name of the database in the Default Database box.
- Click
to select a database from the list.
If adding a query and the database, tables, and view names in the new query are fully qualified, it is not necessary to select a database. - In the QCD Name box, do one of the following:
- Type the database name.
- Click to select a database from the list.
- Select queries using any of the following options:
- In Export Options, select the appropriate check boxes to define the exported information. See Export Options.
- [Optional] To further define the selected export options for the query, click Options.The options available in the Export Options dialog box depend on the selections made under Export Options in the Export By Query dialog box. See Export Options.If a selected query contains a problem, clicking Options displays a Warnings dialog box. To resolve the warning, change the query or remove it from Selected Queries.
- [Optional] To customize the headings under Selected Queries:
- Right-click on the heading row.
- Select a command from the shortcut menu.
- [Optional] Click Estimate Time to view an estimate of the time needed to export each object.
- Click to begin the export process.The export-by-query operation uses the SHOW QUALIFIED statement. To avoid errors, only input DML statements, not DDL statements. If there is an error, a Warning dialog box appears. Modify the statement before restarting the export operation. After the export operation completes, a summary report of the export operation results appears. See Viewing a Summary Report. Queries which call stored procedures are separated out before submitting SHOW QUALIFIED. The separated queries (calling Stored Procedures) are parsed to get the Stored Procedure object and SHOW PROCEDURE is submitted to retrieve the Stored Procedure Object Definition. Nested Stored Procedures are also captured.