Code: Select all
PathName = ValueFileDir:'/':ValueFile
Cmd2="cat ":PathName
Call DSExecute("UNIX",Cmd2,ValueFileOutput2,SystemReturnCode2)
File=ValueFileOutput2
If SystemReturnCode2= 0 then
Value1=Field((File<1>),'=',2)
Value2=Field((File<3>),'=',2)
Value3=Field((File<4>),'=',2)
Value4=Field((File<5>),'=',2)
Value5=Field((File<6>),'=',2)
Value6=Field((File<7>),'=',2)
Value7=Field((File<8>),'=',2)
End
Else
Call DSLogFatal("Unable to open Value File ":PathName, "MyRoutine")
Ans=1
End
-------------------------
* Set parameters for the Job
ErrCode= DSSetParam (hJob, "DirName", Value1)
ErrCode= DSSetParam (hJob, "FileName", Value2)
ErrCode= DSSetParam (hJob, "SchemaDirName", Value3)
ErrCode= DSSetParam (hJob, "SchemaFileName", Value4)
ErrCode= DSSetParam (hJob, "InsQuery", Value5)
ErrCode= DSSetParam (hJob, "UpdQuery", Value6)
ErrCode= DSSetParam (hJob, "FilterStmt", Value7)
ErrCode= DSRunJob(hJob, DSJ.RUNNORMAL)
Parameters have some special characters like " / = ." , will those cause any problem. Am reading the parameters from a file & assigning them to Job.
when I read the parameters it's returning correct parameters but not assigning them to Job. point me where I went wrong.
kindly help.