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.
- Add the directory where BTEQ resides to the search path.
- Change directory to the BTEQ directory.
- 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:
- 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.
- 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
*** 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. - 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
- Log off of the Teradata Database and exit BTEQ.