17.00 - 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.00
Published
November 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
iba1544831946725.ditamap
dita:ditavalPath
hrk1498764225196.ditaval
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.00.00.00 for platform. PID nnnn.
    Copyright 1984-2019, Teradata Corporation. 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.00.00.00
    *** Teradata Database Version is 17.00.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.00.00.00 for platform
     CLIV2      : 17.00.00.00
     COPERR.H   : 17.00.00.00
     COPTYPES.H : 15.10.00.00
     DBCAREA.H  : 17.00.00.00
     DBCERR.H   : 15.10.00.00
     DBCHQEP.H  : 17.00.00.00
     MOSIIF.H   : 17.00.00.00
     PARCEL.H   : 17.00.00.00
     PIOM       : 17.00.00.00
     TDICU      : 17.00.00.00
     TDWALLET   : 17.00.00.00
     Database   : 17.00.00.00
      
     BTEQ linking date is Apr 17 2017
    
  7. Log off of Vantage and exit BTEQ.