SHOW VERSIONS
Purpose
Returns 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 a Teradata SQL macro.
Example
To see the revision levels and overall version number for the BTEQ software currently running, invoke BTEQ and then specify:
.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
The Example 1 SHOW VERSIONS command in a Teradata SQL macro appears as:
ECHO '.SHOW VERSIONS';