Version Value for every run

[vinodhraj]

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

[ArndW]

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

[ray.wurlod]

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.