Submit Output as Input | Basic Teradata Query - 17.00 - Submitting Output as Input - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

Use the following steps to resubmit output as input:

  1. Use the BTEQ EXPORT command to specify the export file.
  2. Use SQL SELECT statements to retrieve data.
  3. Use the RESET option of the BTEQ EXPORT command to close the export file.
  4. Use the BTEQ IMPORT command to specify the file as an import file, using the same format specification used for the EXPORT command in step 1.
  5. Use SQL statements with USING modifiers to resubmit the output data as input.