DSGetStageInfo with dataset

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajan.n
Premium Member
Premium Member
Posts: 96
Joined: Mon Oct 09, 2006 7:47 am

DSGetStageInfo with dataset

Post by rajan.n »

Hi All,
i have a routine which am using DSGetStageInfo in that.
The routine works fine.
But unfortunately this routine fails when it comes to a dataset stage in a job.

the Warning it gives is

"Jobname1.BeforeJob (DSGetStageInfo): Job control error (-7)
(DSGetStageInfo) Unknown stage name StageName_DS in job MainJob."

my doubt is does DSGetStageInfo performs on dataset stage..?
if not , can anybody help me who got knowledge on this..?

thanks much in advance.

Rajan.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

It should work. Are you giving the correct name of the stage? Make sure there are no leading/trailing spaces.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
rajan.n
Premium Member
Premium Member
Posts: 96
Joined: Mon Oct 09, 2006 7:47 am

Post by rajan.n »

DSguru2B wrote:It should work. Are you giving the correct name of the stage? Make sure there are no leading/trailing spaces. ...
Hi DSguru thnx for the reply,
yes my routine works fine with all the stages except this dataset !!

the routine itself uses code for the stage name.
StageList = DSGetJobInfo (JobHandle, DSJ.FULLSTAGELIST )
count = Count(StageList,",")
for i = 1 to count + 1
StageName = Field(StageList,",", i)
....................
jst pasted relevent code from my routine.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Does it fail for any other stage types? In server jobs DSGetStageInfo() only works for active stages. Try using DSJ.STAGELIST rather than DSJ.FULLSTAGELIST.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rajan.n
Premium Member
Premium Member
Posts: 96
Joined: Mon Oct 09, 2006 7:47 am

Post by rajan.n »

ray.wurlod wrote:Does it fail for any other stage types? In server jobs DSGetStageInfo() only works for active stages. Try using DSJ.STAGELIST rather than DSJ.FULLSTAGELIST. ...
Hi ray
thnx for the reply,
yes this is frst time facing error (on only dataset)
and it did not give any warnign or error on any other stages.
(for ex: Seq file , we have run this routine on many jobs which has seq file stage but no problem up to now.)
if that true ( DSStageInfo acts only on active stages), do we have any method to know how we deal wth the passive stages.

Once again thanks for the reply.
Rajan
Post Reply