Purpose
Lists version levels for BTEQ and the key Teradata software it depends on.
Syntax
Usage Notes
Use the SHOW VERSIONS command to determine which version of BTEQ is running. The results of this command include associated revision levels for BTEQ’s critical software modules that are helpful when reporting BTEQ problems to product support personnel.
The SHOW VERSIONS command can be used in an SQL macro.
Example 1 – SHOW VERSIONS
To see the revision levels and overall version number for the BTEQ software currently running, invoke BTEQ and then specify the following:
.SHOW VERSIONS
BTEQ Response
Mainframe- and workstation-attached systems return different information. The examples that follow can differ from the responses received, depending on the operating system and CLI/Data Connector/TDICU/TeraGSS and Database version used.
Workstation-Attached Systems
.show versions; BTEQ Version 14.00.00.00 for Win 32 running Windows Sockets CLIV2 : 14.10.00.00 COPERR.H : 14.10.00.01 COPTYPES.H : 14.10.00.01 DBCAREA.H : 14.10.00.01 DBCERR.H : 13.10.00.00 DBCHQEP.H : 14.10.00.00 MOSIIF.H : 14.10.00.02 PARCEL.H : 14.10.00.05 TeraGSS : 14.10.00.00 PIOM : 14.10.00.00 TDICU : 14.10.00.00 TDWALLET : 14.10.00.00 Database : 14.10.00.00 BTEQ linking date is Apr 23 2012
Mainframe-Attached Systems
.SHOW VERSIONS The following is what the results should look similar to for a z/OS BTEQ build : .SHOW VERSION ; BTEQ Version 14.00.00.00 for z/OS (IBM/C) CLIV2 : 14.00.00 COPERR.H : 13.10.00.00 COPTYPES.H : 13.10.00.00 DBCAREA.H : 13.10.00.03 DBCERR.H : 13.10.00.00 DBCHQEP.H : 13.10.00.02 PARCEL.H : 13.10.00.04 TDICU : 14.00.00.00 Database : 14.00.00.00 BTEQ linking date is Oct 13 2010
Example 2 – SHOW VERSIONS Instigated By a Macro
The SHOW VERSIONS command in an SQL macro appears as follows:
ECHO '.SHOW VERSIONS';