BTEQ is one of most powerful utility in Teradata which is useful for both Batch and Interactive mode. BTEQ is used to run DDL statement, DML statement, create macros and store procedures. BTEQ can be used to import data into Teradata tables from flat file and it can also be used to extract data from tables into files or reports.
One of the important use of BTEQ to import data from a flat-file. BTEQ is also useful to extract data from tables into files or in reports.
Below is the commonly used scripts in BTEQ.
- LOGOFF − Logs off from database and terminates all sessions.
- IMPORT − Specifies the input file path.
- LOGON − Used to log into Teradata system.
- ACTIVITYCOUNT − Returns the number of rows affected by the previous query.
- LABEL − Assigns a label to a set of SQL commands.
- RUN FILE − Executes the query contained in a file.
- ERRORCODE − Returns the status code of the previous query.
- DATABASE − Sets the default database.
- GOTO − Transfers control to a label.
- EXPORT − Specifies the output file path and initiates the export.
