Datastage returns fake return code

cheerfu1 · Post by **cheerfu1** » Wed Aug 10, 2005 7:14 pm

I am using After-Job routine to create a file which indicates the job has finished. However, when I used the following code, it always return a status 0 no matter it was stopped or was run successfully. Any clue?

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H

RoutineName = 'isFinished'

Output = 0
SystemReturnCode = 0

Call DSExecute('DOS', 'sleep 20 s', Output, SystemReturnCode)

JobStatus = DSGetJobInfo(DSJ.ME, DSJ.JOBSTATUS)

Call DSLogInfo(JobStatus, "IsFinished")

ErrorCode = 0      ;* set this to non-zero to stop the stage/job
If JobStatus = 0 or JobStatus = 1 or JobStatus = 2 Then
   ExecName = 'touch ' : InputArg : '.test'
   Call DSExecute('DOS', ExecName, Output, SystemReturnCode)
   ErrorCode = 0
   RETURN
End Else
   Call DSLogInfo(JobStatus, "IsFinished")
   ErrorCode = JobStatus 
   RETURN
End

ray.wurlod · Post by **ray.wurlod** » Wed Aug 10, 2005 7:28 pm

Code: Select all

JobStatus = DSGetJobInfo(DSJ.ME, DSJ.JOBINTERIMSTATUS)

cheerfu1 · Post by **cheerfu1** » Wed Aug 10, 2005 7:39 pm

It does not seem to run in DS 4.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 10, 2005 10:48 pm

True, it was introduced in version 7.x, so you need to interrogate tha job status after the job has completed successfully. Typically this will be from the job control routine from which you requested execution of the job run. Or upgrade.