15.10 - DBCInfoV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

InfoKey

VARCHAR(30) LATIN

NOT CASESPECIFIC

NOT NULL

X(30)

DBCInfoTbl.InfoKey (UPI)

InfoData

VARCHAR(16384)

UNICODE

NOT CASESPECIFIC

X(16384)

DBCInfoTbl.InfoData

This SELECT statement retrieves the version and release of the current Teradata Database 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