/* The attribute is (LogonMech = 'ldap') */ /* Below is simple example: tpt.job and variables file, */ /* to run --> tbuild -f tpt.job -v variables.txt */
/* variables.txt */ SourceTdpId = 'lnx2019' ,SourceUserName = 'username' ,SourceUserPassword = 'password' ,LogonMech = 'ldap' ,DDLPrivateLogName = 'ddlprivate.log' ,ExportPrivateLogName = 'exportprivate.log' ,TargetErrorList = ['3807'] ,TargetFileName = 'flatfile2.dat' ,TargetFormat = 'delimited' ,TargetTextDelimiter = ',' ,TargetOpenMode = 'write' ,SelectStmt = 'SELECT * FROM dbc.dbcinfo;'
/* tpt.job */ DEFINE JOB qstart2 ( APPLY TO OPERATOR ($FILE_WRITER) SELECT * FROM OPERATOR($EXPORT); );
You can defined the "Logonmech " in the TPT script and you can give a value from the command line through a -u option. varchar Logonmech='ldap' Alternatively you can say in TPT script like below: Logonmech=@mech
And then give it a value like: tbuid -f ... ... -u "mech='ldap'"
|