Job Variable File - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.00
Published
November 30, 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
sch1544831938749.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities
The parameters inside <> brackets need to be replaced appropriately and <> brackets need to be removed.
/********************************************************/
/* TPT attributes - Common for all Samples              */
/********************************************************/
TargetTdpId = '<Teradata Database ID>'
,TargetUserName = '<TargetUserName>'
,TargetUserPassword = '<TargetUserPassword>'
,TargetErrorList = [ '3706','3803','3807' ]
,DDLPrivateLogName = 'DDL_OPERATOR_LOG'

/********************************************************/
/* TPT LOAD Operator attributes                         */
/********************************************************/

,LoadPrivateLogName = 'LOAD_OPERATOR_LOG'
,LoadTargetTable = 'GCSW001'
,LoadLogTable = 'GCSW001_log'
,LoadErrorTable1 = 'GCSW001_e1'
,LoadErrorTable2 = 'GCSW001_e2'

/********************************************************/
/* TPT DataConnector Producer Operator                  */
/********************************************************/

,FileReaderFormat = 'Formatted'
,FileReaderPrivateLogName = 'GCSW001P2_1'
,FileReaderOpenMode = 'Read'

/********************************************************/
/* APPLY STATEMENT parameters                           */
/********************************************************/
,LoadInstances = 1
,FileReaderInstances = 1