passing Unix command Output as command in Batch job

[sumeet]

Hi ,

I am trying to pass parameter which I get from a file to the batch job.

The output of unix command is correct I check it using DSLogInfo before the DSSetParam step. But the value is not passed to the Parameter. I dont understand why. Here's the code

Code: Select all

Cmd = "cat /clocal/ivp/dvlp/tmp/Param.txt":"|cut -c2-5"
	 
        Call DSExecute("UNIX", Cmd, Output, SystemReturnCode)

        Ans = Output
      
        
* Setup Test7Job, run it, wait for it to finish, and test for success
         hJob1 = DSAttachJob("Test7Job", DSJ.ERRFATAL)
         If NOT(hJob1) Then
            Call DSLogFatal("Job Attach Failed: Test7Job", "JobControl")
            Abort
         End
         ErrCode = DSSetParam(hJob1, "$ivpDirParm", "$ENV")
         ErrCode = DSSetParam(hJob1, "$ivpDB2User", "$ENV")
         ErrCode = DSSetParam(hJob1, "$ivpDB2Passwd", "$ENV")
         ErrCode = DSSetParam(hJob1, "$ivpDB2DBStg", "$ENV")
         ErrCode = DSSetParam(hJob1, "$ivpDirTmp", "$ENV")
         Call DSLogInfo('Output = ': Output, 'Msg') /*Output=PH02*/
         ErrCode = DSSetParam(hJob1, "PHID",Output) /*here PHID=''*/
         ErrCode = DSRunJob(hJob1, DSJ.RUNNORMAL)
         ErrCode = DSWaitForJob(hJob1)
         Status = DSGetJobInfo(hJob1, DSJ.JOBSTATUS)
         If Status = DSJS.RUNFAILED Or Status = DSJS.CRASHED Then
            * Fatal Error - No Return
            Call DSLogFatal("Job Failed: Test7Job", "JobControl")
         End

Can any of DS gurus help me.

Thanks
Sumeet

[chulett]

Are you getting an error? Or it just "doesn't work"?

Try passing Output<1> to the parameter value rather than just Output.

[sumeet]

Thanks Chulett

This worked....so is it a syntax where when u pass parameter from command.

Output<i>..i is the count of prameters passed...in this case 1.

Thanks
Sumeet

[chulett]

No, not parameters passed.

You have to keep in mind the fact that your 'Output' from DSExecute is not a simple string, it's a dynamic array of values. That syntax just means take the first entry from it, which is all you really wanted in this case. If your output was multiple 'records', each would be accessed in a similar manner.

When you take everything in one string, you get the bits that make up the internal structure of the array along with the data - stuff like the @FM Field Marks... or whatever the secret stuff that is in there.