Submitting Output as Input - Basic Teradata Query

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.