range for KeyMgtGetNextValueConcurrent
Posted: Mon May 18, 2009 10:08 am
Hi,
I am using two jobs to populate surrogate key on a table. Is there a way that I could mention definite range of values using KeyMgtGetNextValueConcurrent i.e. mentioning that Job1 should generate keys 1-1000 and Job2 should generate keys 1001-2000. If overflow, then they start from beginning of their range.
Thanks
I am using two jobs to populate surrogate key on a table. Is there a way that I could mention definite range of values using KeyMgtGetNextValueConcurrent i.e. mentioning that Job1 should generate keys 1-1000 and Job2 should generate keys 1001-2000. If overflow, then they start from beginning of their range.
Thanks