Need to get the file of DataStage generating seqnumber

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Xpert
Premium Member
Premium Member
Posts: 85
Joined: Wed Mar 01, 2006 7:17 am

Need to get the file of DataStage generating seqnumber

Post 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.....
With regards,
Xpert
loveojha2
Participant
Posts: 362
Joined: Thu May 26, 2005 12:59 am

Post 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.
Success consists of getting up just one more time than you fall.
Xpert
Premium Member
Premium Member
Posts: 85
Joined: Wed Mar 01, 2006 7:17 am

hi

Post 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
With regards,
Xpert
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply