Validating the BTEQ Installation - Teradata Tools and Utilities

Teradata® Tools and Utilities for Linux Installation Guide Amazon Linux 2, CentOS, OEL, RedHat, SLES, Ubuntu

Product
Teradata Tools and Utilities
Release Number
16.20
Published
November 2020
Language
English (United States)
Last Update
2020-11-19
dita:mapPath
del1512703274392.ditamap
dita:ditavalPath
linux_No_ie.ditaval
dita:id
B035-3160
lifecycle
previous
Product Category
Teradata Tools and Utilities
Refer to Basic Teradata® Query Reference (B035-2414) for detailed information on how to use BTEQ.
  1. Change directory to the BTEQ directory.
  2. Start BTEQ:

    bteq

    Output similar to the following appears:
    Teradata BTEQ 16.20.00.00 for platform. PID nnnn.
    Copyright 1984-2017, Teradata Corporation. ALL RIGHTS RESERVED.
    Enter your logon or BTEQ command:
  3. 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.

  4. 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
    Output similar to the following appears:
    *** Logon successfully completed.
    *** Teradata Database Release is 16.20.00.00
    *** Teradata Database Version is 16.20.00.00
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'. 
    
    *** Total elapsed time was 1 second. 
                        
    BTEQ -- Enter your SQL request or BTEQ command:
    For information about security and connecting to a Teradata Database, see Teradata® Database Security Administration (B035-1100).
  5. 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.
    
      Time                   
    --------                  
    11:09:11
  6. To see the version numbers for BTEQ and the key Teradata software it depends on, use the following BTEQ command:

    .SHOW VERSIONS

    which produces output similar to the following:
    .SHOW VERSIONS
     BTEQ Version 16.20.00.00 for platform
     CLIV2      : 16.20.00.00
     COPERR.H   : 16.00.00.00
     COPTYPES.H : 15.10.00.00
     DBCAREA.H  : 16.00.00.01
     DBCERR.H   : 15.10.00.00
     DBCHQEP.H  : 16.00.00.03
     MOSIIF.H   : 16.00.00.03
     PARCEL.H   : 16.00.00.05
     PIOM       : 16.20.00.00
     TDICU      : 16.20.00.00
     TDWALLET   : 16.20.00.00
     Database   : 16.20.00.00
      
     BTEQ linking date is Apr 17 2017
    
  7. Log off of the Teradata Database and exit BTEQ.