Hi,
Under repository, - Routines - SDK, there are routines KeyMgtGetNextValueConcurrent
KeyMgtGetMaxKey
KeyMgtGetMaxKeyFromODBCToUSER
KeyMgtGetNextValue
When I go to Transformer, Select DSROUTINES - Routines - SDK, I se only one routine
KeyMgtGetMaxKeyFromODBCToUSER
Can you tell me how to view other SDK key routines in Transformer?
Thanks
ketfos
KeyMgtGetNextValueConcurrent routine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks.
yes it has transform associated with it.
That is why it is not displayed...
The description of this routine is ---
"Routine to generate a sequential number.
The routine argument is the name associated with the sequence.
The routine uses a file to store the next available number. It reads the number from the file on each invocation; a lock on the file prevents concurrent access."
Where is the file stored? Is it internal to datastage?
Ketfos
yes it has transform associated with it.
That is why it is not displayed...
The description of this routine is ---
"Routine to generate a sequential number.
The routine argument is the name associated with the sequence.
The routine uses a file to store the next available number. It reads the number from the file on each invocation; a lock on the file prevents concurrent access."
Where is the file stored? Is it internal to datastage?
Ketfos
ketfos
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
SDKSequences hash file
KeyMgtGetNextValueConcurrent - I used this in the transformer KeyMgtGetNextValueConcurrent(1) in one job and KeyMgtGetNextValueConcurrent(2) in another job.
I ran the first job for 100 rows and second job for 10 rows.
It generated the key values starting from 1..100 and 1..10 in each case.
I see a hash file SDKSequences in the project folder.
When I query the hash file using select * from SDKSequences, it returns two records with value 1 and 2.
How do I set the counter to start value of 1 for each of the job.
i.e i want surrogate key generation to start from 1.
Thanks
Ketfos
I ran the first job for 100 rows and second job for 10 rows.
It generated the key values starting from 1..100 and 1..10 in each case.
I see a hash file SDKSequences in the project folder.
When I query the hash file using select * from SDKSequences, it returns two records with value 1 and 2.
How do I set the counter to start value of 1 for each of the job.
i.e i want surrogate key generation to start from 1.
Thanks
Ketfos
ketfos
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: