17.10 - Example: Using DBCInfoV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

This SELECT statement retrieves the version and release of the current Advanced SQL Engine software.

SELECT infokey (format ‘x(30)’),
      infodata (format ‘x(20)’)
  FROM DBC.DBCInfoV
  ORDER BY infokey;

Result:

InfoKey                        InfoData
---------------------          --------------------
LANGUAGE SUPPORT MODE          Japanese
RELEASE                        14.10j.00.00
VERSION                        14.10j.00.00   

For the language support mode, InfoData is either Standard or Japanese.

The values for Version and Release are broken down into 4 parts:
  • Major release
  • Minor release
  • Maintenance release
  • E-fix release

For example, 14.10.02.03 represents the following:

Value Description
14 Major release number
10 Minor release number
02 Maintenance release number
03 E-fix or patch release number