Row Counts and UserVariable activity
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
Row Counts and UserVariable activity
Hi,
In the server world I would always store values in a hash file and look them up in the UserVariable stage. I now have parallel jobs where I am retrieving row counts (into a sequential file for now). How can I get those counts into the UserVariable activity stage in my sequence?
Basically I am looking to terminate processing if any onbe of many row counts iz zero.
Thanks - - John
In the server world I would always store values in a hash file and look them up in the UserVariable stage. I now have parallel jobs where I am retrieving row counts (into a sequential file for now). How can I get those counts into the UserVariable activity stage in my sequence?
Basically I am looking to terminate processing if any onbe of many row counts iz zero.
Thanks - - John
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
I have tools that allow you to store and retrieve values from a parameter table, and access them from within a sequence. They may help. Look at the DataStage Tools page on www.anotheritco.com .
Chuck Smith
www.anotheritco.com
www.anotheritco.com