BTEQ in Teradata

       Basic Teradata Query (BTEQ) :-

BTEQ stands for basic Teradata queries. In simple word we can define bteq as a utility which allows users to query, import and export data and produce reports. It’s a command driven utility.  It’s a tool for Teradata same like sqlplus in oracle. We can use bteq in interactive or batch mode.

With the help of bteq we can perform following activities:-

  

    1)  Teradata SQL statements to view, add, modify, and delete data;

      2)     BTEQ commands; like logon and logoff

      3)    Operating system commands;

      4)    Create and use Teradata stored procedures.

A sample bteq script can be like shown below:-

We can execute above bteq script as shown below:-

Bteq < infile > out_file

Below is a sample part of the bteq log file:

Note: - whatever we have seen is just a basic of the Mload, Fload and bteq utilities we can use more advance features of Teradata in these tools.

Read Also:-