17.05 - Writing the JobVariablesFile - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K
  • Write the JobVariablesFile by substituting values for variables in the following script:
    DDLTdpId               = 'td_host_name_or_ip'
    ,DDLUserName           = 'td_user'
    ,DDLUserPassword       = 'td_user_password'
    ,DDLErrorList          = ['3807']
    ,DDLPrivateLogName     = 'DDL001S1'
    ,TargetTable           = 'td_table_name'
    ,ODBCPrivateLogName    = 'ODB039P1'
    ,ODBCDSNName           = 'Data_Source_Name_specified_in_DSN_Setup_form'
    ,TruncateData          = {'Y' | 'N'}
    ,ODBCUserName          = 'aster_user'
    ,ODBCUserPassword      = 'aster_user_password'
    ,LOADPrivateLogName    = 'ODB039C1'
    ,LOADTDPID             = 'td_host_name_or_ip'
    ,LOADUserName          = 'td_user'
    ,LOADUserPassword      = 'td_user_password'
    ,SelectStmt            = 'SELECT * FROM aster_table_name;'
    ,LOADTargetTable       = 'td_table_name'
    

    For TruncateData, 'Y' trims unused space. The default is 'N'. Specify 'Y' when the MaxLenVarchar field of the DSN Setup form (in Setting Up the Aster Driver on the Client) exceeds the maximum VARCHAR length specified in TD_compatible_table_definition in the tpt script; otherwise, ODBC cannot load the script.