DSXchange

Hi,

I'm trying to list out the passive stages in a DataStage Parallel Job [DataStage v8.1] using the DSGetJobInfo function.

#### Server Routine Code as below ####
$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle = DSAttachJob(JobName,DSJ.ERRFATAL)

Ans = DSGetJobInfo(JobHandle,DSJ.STAGELIST2)

### End of Code ######

This routine doesn't list out the Oracle Enterprise Stage as a passive stage. Instead it shows up as an active stage. In the repository under Stage Types -> Parallel -> Database, I checked the properties of the Oracle Enterprise stage and found that it is check marked as a Passive stage. In that case why should my routine list it as an active component? Could anyone help?

Thanks
Deepti

Seems like a bug to me. Are you up-to-date on fixpacks? Have you checked with your official support provider?

I checked with the IBM team and they agree that the rutine doesn't work as expected. And I also shared the routine code. They provided a workaround for my code piece. And also conformed that there is no correction for this even in v8.5

Care to share the workaround?

This "issue" has been around since version 1.0, in which the ORABULK stage was an active stage because they felt the need to support after-job subroutine through which sqlldr could be invoked with user-supplied options. I guess it's just continued through.