17.10 - LoadTablesInfoV[X] - 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)

Category: Operations

Database: DBC

View Column Data Type Format Comment
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) TableName is the name of the LDI table in a concurrent load operation.
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) DatabaseName is the database name to which the LDI table in concurrent load operation belongs to.
LoadQueryBand VARCHAR(256) UNICODE NOT CASESPECIFIC NOT NULL X(256) LoadQueryBand is the Query_Band value of the concurrent load operation.
SingleSession CHAR(1) LATIN UPPERCASE NOT NULL X(1) SingleSession specifies if the concurrent load operation is performed by a single session or performed in multiple sessions.
ControlSessNum INTEGER NOT NULL --,---,---,--9 ControlSessNum is the session number of the session that issued BEGIN ISOLATED LOADING.
ControlHostNum SMALLINT NOT NULL ---,--9 ControlHostNum is the logical host ID of the session that issued BEGIN ISOLATED LOADING.
StartTimeStamp TIMESTAMP(6) WITH TIME ZONE NOT NULL YYYY-MM-DDBHH:MI:SS.S(6)Z StartTimeStamp is the timestamp value at the time BEGIN ISOLATED LOADING is processed.