Validating the BTEQ Installation - Teradata Tools and Utilities

Teradata® Tools and Utilities for Oracle Solaris on SPARC and AMD Opteron Systems Installation Guide

Product
Teradata Tools and Utilities
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-01
dita:mapPath
zjd1608578347018.ditamap
dita:ditavalPath
hrk1498764225196.ditaval
dita:id
B035-3136
lifecycle
previous
Product Category
Teradata Tools and Utilities
See the 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 17.10.00.00 for platform. PID nnnn.
    Copyright 1984-2021 Teradata. All rights reserved.
    Enter your logon or BTEQ command:
  3. Log on to Vantage:

    .logon dbcpath/username

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

  4. When prompted, enter the password.
    For example, if Vantage 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 17.10.00.00
    *** Teradata Database Version is 17.10.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 Vantage, see Teradata Vantage™ - Advanced SQL Engine 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 view 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 17.10.00.00 for platform
     CLIV2      : 17.10.00.00
     COPERR.H   : 17.10.00.00
     COPTYPES.H : 17.10.00.00
     DBCAREA.H  : 17.10.00.00
     DBCERR.H   : 17.10.00.00
     DBCHQEP.H  : 17.10.00.00
     MOSIIF.H   : 17.10.00.00
     PARCEL.H   : 17.10.00.00
     PIOM       : 17.10.00.00
     TDICU      : 17.10.00.00
     TDWALLET   : 17.10.00.00
     Database   : 17.10.00.00
      
     BTEQ linking date is May  7 2021
  7. Log off of Vantage and exit BTEQ.