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.
| File Type | ddname | Description |
|---|---|---|
| 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.