The following commands control identification of files used for taking input in the form of instructions and imported data records and then producing output in the form of tabular reports, meta results and exported data records.
| BTEQ Command | Function |
|---|---|
| ERROROUT | Routes the standard error stream and the standard output stream to two files or devices for mainframe-attached systems, or to one file or device for workstation-attached client systems. |
| EXPORT | Specifies the name and format of an export file that BTEQ uses to store records resulting from data-returning SQL requests. |
| IMPORT | Opens a supplied file, of the specified format, to process record data for USING modifiers of subsequent SQL requests. |
| MESSAGEOUT | Specifies the name of a file for BTEQ to store the messages that would normally be sent to the standard output. |
| RUN | Processes the Teradata SQL requests and BTEQ commands from the specified run file. |