Hi,
I want to insert a value incrementally for every run in transformer, so that version of every run is maintained.
I cant use @rownum since it increment for every row.
I should not use database sequence, since it cannot be rollbacked.
Any way using stage variables or any solution?
Thanks
Vinod
Version Value for every run
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use the key management routine when initializing a stage variable, and do not overwrite that value with a stage variable derivation. That way, the function is only evaluated and the number is only allocated once.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.