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. Starting with TTU 15.10, TSET is enhanced to support queries calling stored procedures. 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, see
Teradata Vantage™ - SQL Data Definition Language Detailed Topics
, B035-1184
.
If the DML statements involve NOS foreign tables, then the related object definitions like authorizations and CSV schemas are also exported. TSET does not make any explicit distinction between regular tables and NOS/foreign tables.