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.
Stage Variable intial value
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
Stage Variable intial value
Karthik
Null is Null
Hi I made a little test:
That mean that the default value of a stage variable without any derivation is Null.
![Wink :wink:](./images/smilies/icon_wink.gif)
- * 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"
That mean that the default value of a stage variable without any derivation is Null.
![Wink :wink:](./images/smilies/icon_wink.gif)
Hugo POISSANT
Data Integration director
CGI
Data Integration director
CGI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
A curious discussion, but in the end, give it something so that it never becomes an issue one way or the other.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>