Validating the BTEQ Installation - Teradata Tools and Utilities

Teradata Tools and Utilities for HP-UX Installation Guide

Product
Teradata Tools and Utilities
Release Number
16.20
Published
April 2018
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
mcz1512703202277.ditamap
dita:ditavalPath
hpux_No_ie.ditaval.ditaval
dita:id
B035-3124
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 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.