DSXchange

All,

I would like to know what is the initial value of a stage variable.

In DB side, NULL will be stored as the default value.

Hi I made a little test:

• * Create a job = > Row Generator (RG) > Transformer (T) > Peek (P)
  * One field of RG called Attribut as VarChar(255)
  * In T a stage variable called StageVar as VarChar(255) without any derivation
  * In T a output field have this derivation "DSLink2.Attribut : "@" : StageVar"

In the P the result output like that Peek_3,2: "Attribut:cccc@"

That mean that the default value of a stage variable without any derivation is Null.

In a server job I'd imagine that the variable would be in an unassigned state. But you can check the generated Transformer stage code to verify this.

In a previous life I recall having a saying that "Default" and "Disaster" both begin with the letter "D"......meaning --- if you care about it, assign it a value manually......

A curious discussion, but in the end, give it something so that it never becomes an issue one way or the other.

Ernie