File Control Commands
Use the following BTEQ commands to specify the format of incoming and outgoing information and identify the source and destination of input and output streams:
ERROROUT |
IMPORT |
RECORDMODE |
EXPORT |
INDICATORMODE |
REPEAT |
EXPORTEJECT |
LARGEDATAMODE |
RUN |
HALT EXECUTION |
OS |
TSO |
FORMAT |
QUIET |
= |
Controlling Input Files
Function |
BTEQ Command |
Execute a z/OS TSO command from within the BTEQ environment. |
TSO |
Execute a Windows or UNIX® command from within the BTEQ environment. |
OS |
Execute Teradata SQL requests and BTEQ commands from a specified run file. |
RUN |
Submit the next request a specified number of times. |
REPEAT |
See Chapter 5: “BTEQ Commands” for the complete syntax and description of each command.
Controlling Output Files
Function |
BTEQ Command |
Abort any active requests and transactions and exit BTEQ. |
HALT EXECUTION |
Enable or inhibit the page-oriented format command options. |
FORMAT |
Open a file with a specific format to transfer information from the Teradata Database. |
EXPORT |
Specify the response mode (Field Mode, Indicator Mode, Record Mode, or Multipart Indicator Mode) for data selected from the Teradata Database. |
INDICATORMODE or RECORDMODE or both |