How to Define Input and Output Files for z/OS BTEQ | Basic Teradata Query - Defining Input and Output Files for z/OS BTEQ - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities
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 SQL requests and BTEQ commands that make up a BTEQ job.
Output SYSPRINT Receives the results of the BTEQ job.

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.