Export 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

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. TSET is enhanced to support queries calling stored procedures in the 15.10 release. TSET parses the queries entered in Export by Query interface to determine if there are any queries calling stored procedures. Such queries are separated out and SHOW QUALIFIED is not submitted for those queries. Objects referred to in the Stored Procedures are retrieved by submitting SHOW PROCEDURE. For more information about the SHOW statement and restrictions, refer to SQL Data Definition Language (B035-1184).