How to count incoming and outgoing rowsusing datastage

[raghuv]

Hi everyone

help me to count the incoming rows and outgoing rows...like how many rows have been extracted and loaded.

suggest me any datastage function or any script...

i tried @inrownum and @outRownum system variable functions but dint see exa

[kcbland]

Your link statistics are available for export during and after a job has run. You can use multiple methods to extract these statistics, either use a DS BASIC routine and call the job APIs that give you this information; or use the command line program dsjob with the appropriate switches to extract link information.

[raghuv]

Your link statistics are available for export during and after a job has run. You can use multiple methods to extract these statistics, either use a DS BASIC routine and call the job APIs that give you this information; or use the command line program dsjob with the appropriate switches to extract link information.

Hi .

what klind of DS basic routines can you suggest one appropriate..and call the job api's , wat kind of dsjob shud i use ...be little clear im just a novice in datastage.

[ketfos]

Hi,
Use two DSMacro in transformer

DSLinkRowCount - will give total number of records written
DSRTIRowCount - will give total number of records read


Ketfos

[kduke]

Do you need this information on all jobs or just this job? What are you doing with this information?

[martin]

If are counting incoming and out going rows or want to count no.of rows passing from a particular link in the job, this will work fine.

DSGetLinkInfo(DSJ.ME,%Arg2%,%Arg3%,%Arg4%)

DSJ.ME is Job Name
Arg2 is Stage Name(Odbc or Seq) with in "" ""
Arg3 is Link Name with in "" ""
Arg3 is DSLinkRowCount with In "" ""

[martin]

I Mean all Argunents With In Double qoutes " "

[raghuv]

hi..

i'll try this on monday..thanks for your support.

regards
raghu

[ray.wurlod]

Don't do it at all during execution. One of the fundamental principles of performance is not to impact performance by trying to measure it. These statistics are collected for you. You can get them from "active stage finishing" events in the log (using BASIC code if you must). Why not just invoke the Director, select that even, and print the detail using "print to file" option? The link row counts that other posters have suggested remain available after the job completes, provided that the job is not re-compiled or reset.