17.00 - Validating the BTEQ Installation - Teradata Tools and Utilities

Teradata® Tools and Utilities for Apple macOS Installation Guide

Teradata Tools and Utilities
Release Number
Release Date
June 2020
Content Type
Publication ID
English (United States)
See the Basic Teradata® Query Reference, B035-2414 for detailed information on how to use BTEQ.
  1. Open the terminal.
  2. Change directory to the BTEQ directory.
  3. Start BTEQ:


    Output similar to the following appears:
    Teradata BTEQ for platform.
    Copyright 1984-2017, Teradata Corporation. ALL RIGHTS RESERVED.
    Enter your logon or BTEQ command:
  4. Log on to 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 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 Teradata Vantage™ - Advanced SQL Engine 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. To see the version numbers for BTEQ and the key Teradata software it depends on:


    which produces output similar to the following:
     BTEQ Version for platform
     CLIV2      :
     COPERR.H   :
     DBCAREA.H  :
     DBCERR.H   :
     DBCHQEP.H  :
     MOSIIF.H   :
     PARCEL.H   :
     TERAGSS    :
     PIOM       :
     TDICU      :
     TDWALLET   :
     Database   :
      BTEQ linking date is Feb  4 2014
  8. Log off Teradata Database and exit BTEQ.