15.10 - UDTInfoV - 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)

Schema

DBC

 

View Column

Data Type

Format

Source Table.Column

TypeId

BYTE(6)

NOT NULL

X(12)

UDTInfo.TypeID

DatabaseId

BYTE(4)

NOT NULL

X(8)

UDTInfo.DatabaseId (Composite NUPI)

TypeName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

UDTInfo.TypeName

TypeKind

CHAR(1) LATIN

NOT NULL

X(1)

UDTInfo.TypeKind

INSTANTIABLE

CHAR(1) LATIN

NOT NULL

X(1)

UDTInfo. INSTANTIABLE

FINAL

CHAR(1) LATIN

NOT NULL

X(1)

UDTInfo.FINAL

OperatorAll

CHAR(1) LATIN

NOT NULL

X(1)

UDTInfo.OperatorAll

DefaultTransformGroup

VARCHAR(128)

UNICODE

X(128)

UDTInfo.DefaultTransformGroup

OrderingForm

CHAR(1) LATIN

NOT NULL

X(1)

UDTInfo.OrderingForm

OrderingCategory

CHAR(1) LATIN

X(1)

UDTInfo.OrderingCategory

OrderingRoutineId

BYTE(6)

X(12)

UDTInfo.OrderingRoutine
Id

CastCount

BYTEINT

NOT NULL

--9

UDTInfo.CastCount

OrderingRoutineId

You can specify an Embedded Services ordering routine by setting the OrderingRoutineId column to '000000000000'XB. Embedded Services refers to a procedure in which one of the database integration methods is called directly.

Possible Values for OrderingCategory

 

Value

Description

R

Relative

M

Map

Possible Values for OrderingForm

 

Value

Description

N

None

F

Full

E

Equals only

Possible Values for TypeKind

 

Value

Description

S

Structure

D

Distinct

I

Internal

The following SELECT statement retrieves information about the predefined Array type, ArrayVec, which is provided by the DIP scripts:

SELECT TypeId, TypeKind, OrderingForm, OrderingCategory, CastCount
FROM DBC.UDTInfoV
WHERE TypeName = 'ArrayVec';

The query returns the following result:

TypeId        TypeKind  OrderingForm  OrderingCategory  CastCount
------------  --------  ------------  ----------------  ---------
000090060000  I         F             M                         0