SHOW VERSIONS

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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 a Teradata 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 Example 1 SHOW VERSIONS command in a Teradata SQL macro appears as follows:

ECHO '.SHOW VERSIONS';