I want to get Number of Rows written or updated to the o/p to a variable.
How can i get this.
want to get how many rows written/updated to the o/p file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Fri Jul 13, 2007 6:33 am
want to get how many rows written/updated to the o/p file
V.Sarat Srinivas
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
At unix level you can use this:
. $DSHOME/dsenv
$DSHOME/bin/dsjob -lstages PROJECT_NAME JOB_NAME
you will get the stage names use in the job,you have mentioned in the above command,if you are already aware of output stage name then use :
rowcount=`dsjob -stageinfo PROJECT_NAME JOB_NAME STAGE_NAME(outputname) | grep "In Row Number" |cut -d':' -f2|awk '{printf $1}'`
. $DSHOME/dsenv
$DSHOME/bin/dsjob -lstages PROJECT_NAME JOB_NAME
you will get the stage names use in the job,you have mentioned in the above command,if you are already aware of output stage name then use :
rowcount=`dsjob -stageinfo PROJECT_NAME JOB_NAME STAGE_NAME(outputname) | grep "In Row Number" |cut -d':' -f2|awk '{printf $1}'`
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 26
- Joined: Fri Jul 13, 2007 6:33 am