A standard output file is an output file that is user-defined as the SYSPRINT file. It executes automatically in batch mode when BTEQ is invoked. If a standard output file is not specified, or if the terminal or workstation is defined as the SYSPRINT file, BTEQ displays all output reports and messages on the terminal or workstation screen.
To specify an output file:
System Type |
Specification |
Mainframe-attached |
Use either the BTEQ TDSBTEQ JCL procedure or a DD statement in a standard JCL file to specify the output file as the SYSPRINT file before invoking BTEQ. |
Workstation-attached |
Use the > or >> character to specify an output file when BTEQ is invoked. |
Using the > or >> Characters
Use the > and >> characters to specify output files as follows:
Redirection Operator |
Filename State |
Results |
> (single character) |
New |
The new file is created as the standard output file. |
> (single character) |
Existing |
The existing file is overwritten with new records. |
>> (double characters) |
New |
The new file is created as the standard output file. |
>> (double characters) |
Existing |
The new records are added to the end of the existing file. |
For more information and examples of specifying a standard output file, refer to “Using Scripts, Run Files, Macros, and Stored Procedures” on page 65.
Specifying Output File Block Size
When defining output files, specify a BLKSIZE that is large enough to accommodate the expected results.
Job Type |
Block Size |
Single interactive mode session |
1024K |
Single-session batch job |
1024K |
Large, multi-session job |
4096K |
Specifying Output File Logical Record Length
LRECL specifications for output files must indicate the appropriate record length, plus five additional bytes:
Note: Carriage control for exported REPORT and DIFformat files is not supported for Unicode® when using z/OS BTEQ.