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
How to count incoming and outgoing rowsusing datastage
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
will you be little clear
Hi .kcbland wrote: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.
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.
john
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 "" ""
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 "" ""
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.