Use the following steps to resubmit output as input:
- Use the BTEQ EXPORT command to specify the export file.
- Use SQL SELECT statements to retrieve data from the Teradata Database.
- Use the RESET option of the BTEQ EXPORT command to close the export file.
- 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.
- Use SQL statements with USING modifiers to resubmit the output data as input.