16.10 - Job Variable File - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
16.10
created_date
July 2017
category
Programming Reference
featnum
B035-2425-077K

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 = 'AzureW001'
,LoadLogTable = 'AzureW001_log'
,LoadErrorTable1 = 'AzureW001_e1'
,LoadErrorTable2 = 'AzureW001_e2'

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

,FileReaderFormat = 'Formatted'
,FileReaderPrivateLogName = 'AzureW001P2_1'
,FileReaderFileName = 'AzureW001DT'
,FileReaderDirectoryPath = '.'
,FileReaderOpenMode = 'Read'

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