SHOW VERSIONS Command | Basic Teradata Query - SHOW VERSIONS (SH V) - Basic Teradata Query

Basic Teradata® Query Reference - 20.00
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

Purpose

This command lists version levels for BTEQ and the key Teradata software it depends on.

Syntax



Shorthand Syntax (Interactive Mode Only)
Command Shorthand Command Shorthand
SHOW SH VERSIONS / VERSION V

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

The SHOW VERSIONS output on z/OS indicates whether BTEQ is using a TDP-mediated or a Gateway-mediated CLI, along side the CLIV2 version number. 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 17.10.00.05 (64-bit) for Win 64 running Windows Sockets
CLIV2      : 17.10.00.17
COPERR.H   : 17.10.00.05
COPTYPES.H : 17.10.00.01
DBCAREA.H  : 17.10.00.04
DBCERR.H   : 17.10.00.01
DBCHQEP.H  : 17.10.00.04
MOSIIF.H   : 17.10.00.02
PARCEL.H   : 17.10.00.08
TERAGSS    : 17.10.00.09
PIOM       : 17.10.00.05
TDICU      : 17.10.00.02
TDWALLET   : 17.10.00.19
Database   : 17.10c.00.152

BTEQ linking date is Aug 26 2021

Mainframe-Attached Systems (employing TDP-mediated CLI) 

.SHOW VERSIONS;
BTEQ Version 17.10.00.06 for z/OS (IBM/C)
CLIV2      : 17.10.00.000 (TDP-mediated)
COPERR.H   : 17.10.00.05
COPTYPES.H : 17.10.00.01
DBCAREA.H  : 17.10.00.04
DBCERR.H   : 17.10.00.01
DBCHQEP.H  : 17.10.00.04
PARCEL.H   : 17.10.00.08
PIOM       : 17.10.00.04
TDICU      : 17.10.00.00
Database   : 17.10c.00.152

BTEQ linking date is Nov  3 2021

Mainframe-Attached Systems (employing Gateway-mediated CLI) 

.SHOW VERSIONS;
BTEQ Version 17.10.00.06 for z/OS (IBM/C)
CLIV2      : 17.10.00.18 (GTW-mediated)
COPERR.H   : 17.10.00.05
COPTYPES.H : 17.10.00.01
DBCAREA.H  : 17.10.00.04
DBCERR.H   : 17.10.00.01
DBCHQEP.H  : 17.10.00.04
PARCEL.H   : 17.10.00.08
TERAGSS    : 17.10.00.07
PIOM       : 17.10.00.04
TDICU      : 17.10.00.00
Database   : 17.10c.00.152

BTEQ linking date is Nov  3 2021

Example 2 – SHOW VERSIONS Instigated by a Macro

The SHOW VERSIONS command in an SQL macro appears as follows:

ECHO '.SHOW VERSIONS';