DSXchange

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

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.

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

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

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.