Exporting by Query - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
lth1488824663584.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities
  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. By default, the File Name box displays the name of the target system specified when connecting. See Connect to a Teradata Database.
  4. Specify a path to the folder in which to save the file by doing one of the following:.
    • Type a path in the In folder box
    • Click Browse to locate a destination folder using Windows Explorer.
    By default, the In Folder box displays the path specified in the Options dialog box. See Directory Options.
  5. Click OK. The Export By Query dialog box appears.


  6. 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.
  7. In the QCD Name box, do one of the following:
    • Type the database name.
    • Click to select a database from the list.
  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.
  10. [Optional] To further define the selected export options for the query, click Options. The Export Options dialog box appears. The options available in the 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.
  11. [Optional] To customize the headings under Selected Queries:
    1. Right-click on the heading row.
    2. Select a command from the shortcut menu.


  12. [Optional] Click Estimate Time to view an estimate of the time needed to export each object.

    See Estimate-Time Rights and Viewing the Estimated Export Time.

  13. 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.