Validating the BTEQ Installation - Teradata Tools and Utilities

Teradata® Tools and Utilities for Microsoft Windows Installation Guide

Product
Teradata Tools and Utilities
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-21
dita:mapPath
vun1608578360787.ditamap
dita:ditavalPath
dpj1465132351025.ditaval
dita:id
B035-2407
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. Start BTEQ:

    Start > All Programs > Teradata Client 17.10 > Teradata BTEQ

    Output similar to the following appears:
    Teradata BTEQ 17.10.00.00 for     platform.
    Copyright 1984-2017, Teradata Corporation. ALL RIGHTS RESERVED.
    Enter your logon or BTEQ command:
  2. Log on to Vantage:

    .logon dbcpath/username

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

  3. 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
    If the logon is successful, 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 DBC/SQL request or BTEQ command:
    For information about security and connecting to Vantage, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.
  4. 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
  5. To see the version numbers for BTEQ and the key Vantage software it depends on:

    .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 Feb  4 2014
  6. Log off of Vantage and exit BTEQ.