regarding dsfunctions

[vijaykumar]

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

[narasimha]

Check the online help for DSGetLinkInfo, you can also do a search on the forum.
If you don't get any, get back.

[DSguru2B]

That is not the correct syntax and hence your quest. But as pointed out, you can get syntax like these from DS help.

[ray.wurlod]

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.

[vijaykumar]

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

[DSguru2B]

You can do it in jobcontrol or in after job subroutine.

[ray.wurlod]

You don't call it from any stage - that was my point. Unless, of course, you call it from an after-stage subroutine, which only gets executed once.