LoadTablesInfoV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.