DSXchange

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

I think the best way is to read the sequential file in a server routine to parse the file and returns a flag to continue or abort the sequence and call it from user variable activity.

But you cannot use a server routine in a parellel job .....

The other way is try to read the file from a command task in the sequencer ( use cat command) then pass it to the job or wherever you want

In Windows, that would be 'type' rather than 'cat' unless you have MKS installed.

sajidkp wrote:But you cannot use a server routine in a parellel job .....

Its a sequence not a parallel job. In sequence you can use it without any problem.

Add an execute command stage in sequencer and use its result in user variables.

Thanks everyone!! I ended up going with teh TYPE command and reading an indicator. Works fine!!

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 .