By default, BTEQ writes error messages to the standard output file (STDOUT), along with the data retrieved from the Teradata Database in response to BTEQ commands and SQL requests. On Mainframe-attached systems, and some workstation-attached systems, a standard error output file (STDERR) can be specified for error messages.
For more information about specifying a standard error output file, see Error Handling and ERROROUT.
Depending on the system configuration, a standard error output file can be specified either when BTEQ is invoked or before logging on to a Teradata Database.
Use the following table to specify a standard error output file:
| System Type | Error Output File |
|---|---|
| Mainframe-attached | Use either the BTEQ TDSBTEQ JCL procedure or a DD statement in a standard JCL file to define the ddname of SYSTERM for the STDERR device before invoking BTEQ. |
| Mainframe-attached | Also use the BTEQ TSO command to define the ddname of SYSTERM for the STDERR device. |
| Workstation-attached | Use the > or >> characters to define a standard error output file when BTEQ is invoked. |