Unique Sequence Number

cosec · Post by **cosec** » Tue Jul 03, 2007 12:57 am

ID=KeyMgtGetNextValue(JobName)

Will This routine create unique keys ??? everytime the job is run....

I will be inserting records to a target table and I don't want it to have the same ID...

Is this sufficient....??

sachin1 · Post by **sachin1** » Tue Jul 03, 2007 3:03 am

yes it will create a unique number everytime you execute your job.

cosec · Post by **cosec** » Tue Jul 03, 2007 4:12 am

Where is this Value stored ? Is there a table Datastage uses to store this value ? and is there a way to change this value ?

Hemant_Kulkarni · Post by **Hemant_Kulkarni** » Tue Jul 03, 2007 4:27 am

search on KeyMgmtGetNextValue will give you all the details.

chulett · Post by **chulett** » Tue Jul 03, 2007 7:17 am

Double-click on the routine to examine the source code. You'll need to use the 'Concurrent' version instead if others will be needing sequences for the same table at the same time.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 03, 2007 7:36 am

Non-concurrent does not prevent others from using different sequences. Concurrent allows multiple processes to retrieve keys from the same sequence.

DSguru2B · Post by **DSguru2B** » Tue Jul 03, 2007 7:37 am

cosec wrote:Where is this Value stored ? Is there a table Datastage uses to store this value ? and is there a way to change this value ?

Search on SDKSequences.

cosec · Post by **cosec** » Tue Jul 03, 2007 8:34 am

Thanks a Lot guys

cosec wrote:ID=KeyMgtGetNextValue(JobName)

Will This routine create unique keys ??? everytime the job is run....

I will be inserting records to a target table and I don't want it to have the same ID...

Is this sufficient....??

DSXchange

Unique Sequence Number

Unique Sequence Number

Re: Unique Sequence Number

Re: Unique Sequence Number