Input and output files must be defined to use BTEQ.
- In interactive mode, BTEQ defines these files automatically in the initialization phase.
- In batch mode, the files are user defined and must be defined before invoking BTEQ.
|Input||SYSIN||Contains the Teradata SQL statements and BTEQ commands that make up a BTEQ job.|
|Output||SYSPRINT||Receives the results of the BTEQ job from the Teradata Database.|
To execute BTEQ in interactive mode, either clear the SYSIN file or define it as TERMINAL.
BTEQ writes lowercase letters to its output file. If a printer does not support lowercase letters, use FOLDMODE on printer output to map lowercase characters to uppercase characters.