Submitting Output as Input - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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 from the Teradata Database.
  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.