DSXchange

Hi Team,


We have a requirement, we were generating seq.nextval key through DB insert statements. Is there any way can we capture the same key value with the same job.


kindly let me know your thoughts on the same.



Regards,
S.R

Yes, you can use the Surrogate Key Generator stage.

One of its methods of operation is to retrieve the next value from a database sequence.

It can be made more efficient by retrieving a block of next values (for example the next 200 records at a time) to reduce the number of queries against the database, particularly if the database host is remote from the DataStage engine host.