SHOW VERSIONS - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 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';