Page 1 of 1

Need to get the file of DataStage generating seqnumber

Posted: Wed Jun 28, 2006 12:03 am
by Xpert
Hi all,

I need to find the file which is tracked by datastage when we generate seqnumber by using keymgt. Datastage keeps track of seqnumber in a file whenever it generates. Thanx in Advance.....

Posted: Wed Jun 28, 2006 12:36 am
by loveojha2
Welcome aboard :)
The File Name is SDKSequences.
You can see it being used within the Routines KeyMgtGetNextValueConcurrent and KeyMgtGetNextValue.
This file maintains the sequences.

hi

Posted: Wed Jun 28, 2006 12:47 am
by Xpert
loveojha2 wrote:Welcome aboard :)
The File Name is SDKSequences.
You can see it being used within the Routines KeyMgtGetNextValueConcurrent and KeyMgtGetNextValue.
This file maintains the sequences.
Where i can get that file. See like i am passing a value as 1. at target it generate seqnumber from 1 to 10. This seqnumber is tracked by datastage. I need that file

Posted: Wed Jun 28, 2006 1:15 am
by ray.wurlod
It's a hashed file in your DataStage repository. The key value is the sequence name, while field 1 contains the sequence value. By what mechanism do you want to "get" that file?