Refer to Basic Teradata Query Reference (B035-2414) for detailed information on how to use BTEQ.
- Change directory to the BTEQ directory.
-
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:
-
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 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). -
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
-
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 - Log off of the Teradata Database and exit BTEQ.