system variables

via · Post by **via** » Fri Apr 06, 2007 7:13 am

HI,
Can any one throw light on system variables (@inrownum, @outrownum,@true,@false).Can we use them in transformer stage to get rowcount of specified links?

Thanks..

chulett · Post by **chulett** » Fri Apr 06, 2007 7:25 am

What kind of 'light' are you looking for?

Have you checked the online help for System Variables? The explanations are a little terse there but I haven't really needed more than that to know how to use them. Or if I did, a quick experimental test job or routine helped.

@TRUE and @FALSE are just that, true and false constants that equate to 1 and 0 respectively. Can you use them to get row counts? No. Use them in an expression.

@INROWNUM and @OUTROWNUM are counters for the 'current record number' either coming in or going out of a transformer. Running. Per link. Can you use them to get row counts? Yes, of course.

Are you looking for a 'grand total'? Make sure you understand it's only a grand total if you have the count from the last record.

via · Post by **via** » Fri Apr 06, 2007 7:51 am

Thanks Craig.
Actually we have a routine which we are calling after each job to get jobstarttime, endtime and rowcount.But i am just thinking can we use any variables in transformer stage to get rowcounts.

We need 'grand total'.Its clear.I think calling routine is better.

Thanks

chulett · Post by **chulett** » Fri Apr 06, 2007 7:59 am

If you need running counts within the job, then those system variables will do the trick. After job, for grand totals, best to stick with other mechanisms - DSGetLinkInfo, for example, which I would think is what you are using in your routine.

via · Post by **via** » Fri Apr 06, 2007 8:23 am

Yes Craig we are using DSGetLinkInfo and DSGetJobInfo in routine.Its working fine.Why i posted is-Just curious to know any functions or variables could do this.

Thanks..

ray.wurlod · Post by **ray.wurlod** » Fri Apr 06, 2007 10:19 am

I'm prepared to bet you do NOT require running totals, just the row counts at the end. These are captured for you in the log if you enable APT_PM_ROW_COUNTS (from memory). The DSGetLinkInfo() function can report the total rows on the link or the per-instance (per-node) row counts for that link.

There are no system variables that expose this information once the job run has been completed.