Job Variable File - Access Module

Teradata® Tools and Utilities Access Module Reference - 20.00
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Access Module
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-05-14
dita:mapPath
cya1691484517272.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
hjf1479308836950
lifecycle
latest
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 = 'S3W001'
,LoadLogTable = 'S3W001_log'
,LoadErrorTable1 = 'S3W001_e1'
,LoadErrorTable2 = 'S3W001_e2'

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

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

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