Stage Variables allowing calculations with null operands

Gazelle · Post by **Gazelle** » Wed May 23, 2012 8:24 pm

As stated, our workaround was to split the transformer into 2 stages.

However, we encountered another problem, to do with the last 6 Text stage variables, which was resolved by replacing the "setnull()" with a text string (e.g. "NULL FLAG"), and in the output derivation use:
If svCPItxt="NULL FLAG" Then SetNull() Else scVPItxt

I went back to an earlier version of the job before we split the transformer, and replaced the "SetNull()" functions in the stage variables... and it worked!

Note that I had a similar problem with using SetNull() in loop variables.

Lesson learned:
in v8.5.0.1, do not use SetNull() in Stage Variables or Loop Variables.

chulett · Post by **chulett** » Wed May 23, 2012 9:32 pm

In what release was support for null stage variables added? They didn't up until fairly recently, from what I recall.

ramsubbiah · Post by **ramsubbiah** » Thu May 24, 2012 5:24 am

Hi,
As far my knowledge, earlier versions of DataStage will not accept null values in the Stage variable.

Thanks,
Ram

priyadarshikunal · Post by **priyadarshikunal** » Thu May 24, 2012 5:45 am

chulett wrote:In what release was support for null stage variables added? They didn't up until fairly recently, from what I recall.

I think it was added in 8.5.

Here is a note from Ray from IOD 2010 Rome before 8.5 release.

viewtopic.php?t=133705