15.00 - Verifying the Installation Using Basic Teradata Query - Teradata Tools and Utilities

Teradata Tools and Utilities for IBM AIX Installation Guide

Teradata Tools and Utilities
Release Number
March 2014
English (United States)
Last Update
Using Basic Teradata Query (BTEQ) is the simplest way to verify that Teradata Tools and Utilities has been installed properly because BTEQ files are part of the installation. Refer to Basic Teradata Query Reference, B035-2414 for detailed information on how to use BTEQ.
  1. Add the directory where BTEQ resides to the search path.
  2. Change directory to the BTEQ directory.
  3. Start BTEQ:


    Output similar to the following appears:
    Teradata BTEQ for platform.
    Copyright 1984-2014, Teradata Corporation. ALL RIGHTS RESERVED.
    Enter your logon or BTEQ command:
  4. Log on to the Teradata Database:

    .logon dbcpath/username

    Enter the BTEQ logon command with a logon ID. Include the dbcpath if the Teradata Database dbcpath is not the default i_dbcpath specified in clispb.dat.

  5. When prompted, enter the password. For example, if the Teradata Database has a dbcpath of Finance, the username is fml, and the password is fml, type:
    • .logon Finance/fml
    • Password: fml
    If the logon is successful, output similar to the following appears:
    *** Logon successfully completed.
    *** Teradata Database Release is
    *** Teradata Database Version is
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'. 
    *** Total elapsed time was 1 second. 
    BTEQ -- Enter your DBC/SQL request or BTEQ command:
    For information about security and connecting to a Teradata Database, see Security Administration, B035-1100.
  6. Submit a sample Teradata SQL query:

    SELECT time;

    If the test passes, output similar to the following appears.
    *** Query completed. One row found. One column returned.    
    *** Total elapsed time was 1 second.                      
  7. Log off of the Teradata Database and exit BTEQ.