Defining Input and Output Files for z/OS BTEQ

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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.