File Control Commands - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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:

 

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