KeyMgtGetNextValueConcurrent routine

ketfos · Post by **ketfos** » Mon Dec 12, 2011 12:20 pm

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

pandeesh · Post by **pandeesh** » Mon Dec 12, 2011 12:26 pm

i guess you need to customize that!

ray.wurlod · Post by **ray.wurlod** » Mon Dec 12, 2011 1:44 pm

You could try making sure that they're compiled. Are they perhaps to be found under DS Functions rather than Functions in the operand menu?

chulett · Post by **chulett** » Mon Dec 12, 2011 5:08 pm

Those have transforms associated with them, from what I remember. Once those are in place they no longer appear in the list of routines.

ketfos · Post by **ketfos** » Tue Dec 13, 2011 6:33 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Dec 13, 2011 7:18 pm

Source for the routine should be in your Repository under the Routines branch.

chulett · Post by **chulett** » Tue Dec 13, 2011 10:29 pm

In there you'll see it uses an account-based hashed file (type 2 from what I recall) to store the values you've passed in and the current surrogate for each value.

ketfos · Post by **ketfos** » Wed Dec 14, 2011 1:14 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Dec 14, 2011 2:37 am

Did you Search DSXchange for an answer?
This post has three different techniques.

KeyMgtGetNextValueConcurrent routine

KeyMgtGetNextValueConcurrent routine

SDKSequences hash file