15.10 - InDoubtLogV - 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

LogicalHostId

SMALLINT

NOT NULL

---,--9 (explicit)

InDoubtResLog.LogicalHostId (Composite NUPI)

SessionNumber

INTEGER

NOT NULL

--,---,---,--9 (explicit)

InDoubtResLog.SessionNumber (Composite NUPI)

CoordTaskId

VARBYTE(30)

NOT NULL

X(60)

InDoubtResLog.CoordTaskId (Composite NUPI)

RunUnitId

VARBYTE(30)

NOT NULL

X(60)

InDoubtResLog.RunUnitId (Composite NUPI)

LogonUserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

InDoubtResLog.LogonUserName

ResolvingUserLogonName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

InDoubtResLog.ResolvingUserLogon
Name

CommitOrRollback

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

InDoubtResLog.CommitOrRollback

UserLogonDate

DATE

NOT NULL

YY/MM/DD (explicit)

InDoubtResLog.UserLogonDate

UserLogonTime

TIME

NOT NULL

99:99:99 (explicit)

InDoubtResLog.UserLogonTime

CompletionDate

DATE

NOT NULL

YY/MM/DD (explicit)

InDoubtResLog.CompletionDate

CompletionTime

TIME

NOT NULL

99:99:99 (explicit)

InDoubtResLog.CompletionTime

Options

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

InDoubtResLog.Options

Possible Values for CommitOrRollback

 

Value

Description

C

Committed

R

Rolled back