how to find out howmany records were processed and rejected

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

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

Post by DSguru2B »

Well you are right so far. Now tell me what do you want to do with this count. Do you want to stick it in the reject file as an extra column with all the records, or what exactly do you want to do with it?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
loveojha2
Participant
Posts: 362
Joined: Thu May 26, 2005 12:59 am

Post by loveojha2 »

sb_akarmarkar wrote:

It will wait for link .....
It won't, until you have designed it that way, I have tried with exactly what you mentioned the result is all zeroes for all the link counts.
Success consists of getting up just one more time than you fall.
sb_akarmarkar
Participant
Posts: 232
Joined: Fri Sep 30, 2005 4:52 am
Contact:

Post by sb_akarmarkar »

loveojha2 wrote: It won't, until you have designed it that way, I have tried with exactly what you mentioned the result is all zeroes for all the link counts.
Try to get Just before target stage, Just plan it ..............

Thnaks,
Anupam
loveojha2
Participant
Posts: 362
Joined: Thu May 26, 2005 12:59 am

Post by loveojha2 »

sb_akarmarkar wrote:
Try to get Just before target stage, Just plan it ..............

Thnaks,
Anupam
That's what I meant when I said
until you have designed it that way
Success consists of getting up just one more time than you fall.
kjaouhari
Participant
Posts: 325
Joined: Thu Mar 16, 2006 10:22 am

Post by kjaouhari »

Hi all !!!
I try to do this :
-------------------------------------------
Suppose
Source Link name is SrcLink
Target Link name is TgtLink
Transformer name between is TransformerX
Link one more transformer name TransformerY to TransformerX
Put constraints @OUTROWNUM = 1

Give following in TransformerY for link count
DSGetLinkInfo(DSJ.ME, "TransformerX", "SrcLink" ,DSJ.LINKROWCOUNT)
DSGetLinkInfo(DSJ.ME, "TransformerX", "TgtLink" ,DSJ.LINKROWCOUNT)

Thanks,
Anupam
---------------------------------------------
So In the second transformer I set DSGetLinkInfo .... in derivation of output colum but I have 0 for all rows.

Could you please more precise where you set DSGetLinkInfo... in transformer x?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You don't.

That would not make sense, and would slow down execution to an unacceptable degree.

You do it in an after-stage subroutine, an after-job subroutine, or in a routine invoked from a Routine activity after the job has completed.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply