15.00 - Verifying the Installation Using Basic Teradata Query - Teradata Tools and Utilities

Teradata Tools and Utilities for Red Hat Enterprise Linux Installation Guide

prodname
Teradata Tools and Utilities
vrm_release
15.00
created_date
March 2014
category
Installation
featnum
B035-3121-034K
Using Basic Teradata Query (BTEQ) is the simplest way to verify that Teradata Tools and Utilities has been installed properly because BTEQ files are part of the installation. Refer to Basic Teradata Query Reference, B035-2414 for detailed information on how to use BTEQ.
  1. Add the directory where BTEQ resides to the search path.
  2. Change directory to the BTEQ directory.
  3. Start BTEQ:

    bteq

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

  5. 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
    If the logon is successful, output similar to the following appears:
    *** Logon successfully completed.
    *** Teradata Database Release is 15.00.00.00
    *** Teradata Database Version is 15.00.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 a Teradata Database, see Security Administration, B035-1100.
  6. 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
  7. Log off of the Teradata Database and exit BTEQ.