User Status

Raftsman · Post by **Raftsman** » Tue Nov 21, 2006 12:35 pm

Hopefully my last question for this topic. I created a server job that reads from DB2 into a transformer stage variable. The value is stored in the userstatus through a routine. Because I don't have an output area defined, I receive errors. How can I get around this without writing to output. Is there a dummy stage I can use to fool DS.

Thanks

narasimha · Post by **narasimha** » Tue Nov 21, 2006 12:41 pm

You could write it to sequential file with the file name as /dev/null if it was in unix. You need to figure out what is the equivalent in the windows world.

narasimha · Post by **narasimha** » Tue Nov 21, 2006 12:51 pm

Looks like the equivalent of /dev/null on unix is NUL on dos. I have not checked though.

Raftsman · Post by **Raftsman** » Tue Nov 21, 2006 1:47 pm

Well I thought it was going to be simple. I coded the following line in the Transformer Stage variable and it didn't like it.

Derivation Stage Variable

StageName.$UserStatus + @NUMPARTITIONS >>>>> svCounter

It can find StageName.$UserStatus

STageName = Transformer_200

I wish the manual had more examples. It would make life much simpler

ray.wurlod · Post by **ray.wurlod** » Tue Nov 21, 2006 4:04 pm

Activity variables (such as $UserStatus) are only accessible in job sequences. You can use it to provide a parameter value to a job parameter in a Job activity. You can not access it directly within the job itself.