DSXchange

Hi All,

I am planning to use KeyMgtGetNextValue for generation of Surrogate Key in multiple Jobs simultaneously.

I want every Job to start the sequence number from 1 and then keep on incrementing. Can it be done using KeyMgtGetNextValue.

What is the best possible way to generate surrogate key in Server mode in multiple different Jobs simultaneously.

each key has a name. If you want to fill different keys you have to use different names. If you want to feed from the same sequence use same name.

Wolfgang

I have different Jobs ( J1 and J2)

And in each of the Jobs i want surrogate keys starting from 1 and getting incremented.

For generating surrogate keys from one sequence simultaneously use KeyMgtGetNextValueConcurrent().

I want to start the Sequence Number from 1 in each case.

Then you may need to reset the sequence name(s) in a before-stage subroutine. Search the forum for "SDKSequences".

The sequences start with 1 and go on incrementing for each sequence name argument specified to this routine.
For Eg: KeyMgtGetNextValue('X') will start from 1 and so will KeyMgtGetNextValue('Y'). Then onwards each sequence shall go on incrementing by 1 for each call made to them. If you want to reset the sequence value you can use an UPDATE statement as below

UPDATE SDKSequences USING DICT VOC SET F1 = 'New Value' WHERE @ID = 'Name of the sequence';

Hope this helps.

anupam wrote:I want to start the Sequence Number from 1 in each case.

Then it doesn't necessarily sound like you even need a Sequence number generator. Are you saying that you need to start them at 1 each time the job is run? If that's the case you could just use @INROWNUM.

Thanks all for the Expert advice, Issue is resolved.

anupam wrote:Thanks all for the Expert advice, Issue is resolved.

Hi Anupam,
Can you please be specific how does yor problem get solved?Have u using update command to set SDK sequence or using @INROWNUM?