DSXchange

Hi,

We would like to populate Jobrunid unique number for all records during the job run.
like for first run it has to populated with 001,second run 002 like that.

Could you please help me on how to get the unique data for all records.

I appreciate your help and time.

Regards
Narasa

reddy wrote:We would like to populate Jobrunid unique number for all records during the job run.
like for first run it has to populated with 001,second run 002 like that.

You can use any sequence generator functionality here.
Either DataStage generated or Database Sequence, but you need to make sure you call it only once in the job and assign that value to a variable or something then use that on all the rows in that job.

The only way, I would think, is to store the value in some file/table, and increment it during each new run.