DSXchange

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

Have you looked into the key management routines supplied in DataStage (KeyMgt)?

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.