Export by Query
This export method uses DML statements to identify database objects to export. The export‑by‑query operation uses the SHOW QUALIFIED statement; therefore, use only DML statements as input. In other words, do not use Data Definition Language (DDL) statements. For more information about the SHOW statement and restrictions, refer to SQL Data Definition Language B035-1184.
To export by query
1 From the main window, click .
The Export from Teradata Database dialog box appears.
2 Click Query.
3 In the File name box, type a file name for the exported emulation information.
4 Specify a path to the folder in which to save the file named in step 3 by doing one of the following:
5 Click OK.
The Export By Query dialog box appears.
Figure 4: Export by Query
6 Define the default database for running queries by doing one of the following:
Note: 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.
7 In the QCD Name box, do one of the following:
8 Select queries using any of the following options:
9 In Export Options, select the appropriate check boxes to define the exported information. See “Export Options”on page 79.
10 [Optional] To further define the selected export options for the query, click Options.
Note: 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.
11 [Optional] To customize the headings under Selected Queries:
a Right‑click on the heading row.
b Select a command from the shortcut menu.Figure 5: Selected Queries for Export
12 [Optional] Click Estimate Time to view an estimate of the time needed to export each object.
13 Click Export to begin the export process.
Note: 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 Warnings 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 “View a Summary Report” on page 136.