Hi gurus,
odbc--->transformer--->odbc.
i want to use DS function in my transformer stage so that it displays all the link information.
i used the function in this way, it says the expression is in valid.
DSGetLinkInfo(DSJ.ME, DSLink3.JOB).
plz help me in validating the expression and where can i get all the link information.
plz help me.
cheers;
vijay
regarding dsfunctions
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It is really bad practice to call DSGetLinkInfo() from within a Transformer stage, because you have to call it for every row processed, and the answer is already there in @INROWNUM or @OUTROWNUM system variables. The overhead of calling it repetitively and unnecessarily will cause poor throughput, about which you will no doubt complain in some other post.
Therefore, if you want the row counts from such a simple job, wait till it's ended and use DSGetLinkInfo() - correctly - then, or get the link row counts from the "active stage finishing" message in the job log, or send the values of @INROWNUM and @OUTROWNUM through an Aggregator stage set to either Last or Max.
Therefore, if you want the row counts from such a simple job, wait till it's ended and use DSGetLinkInfo() - correctly - then, or get the link row counts from the "active stage finishing" message in the job log, or send the values of @INROWNUM and @OUTROWNUM through an Aggregator stage set to either Last or Max.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
hi gurus,
thanks very much. One more thing which is the best way to call this function, as you gurus said that its not best idea to call these functions from transformer stage, then normally where does we use this function, i mean which stage we use to call this function, plz help me.
plz help me.
cheers;
vijay
thanks very much. One more thing which is the best way to call this function, as you gurus said that its not best idea to call these functions from transformer stage, then normally where does we use this function, i mean which stage we use to call this function, plz help me.
plz help me.
cheers;
vijay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: