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....??
Unique Sequence Number
Moderators: chulett, rschirm, roy
Re: Unique Sequence Number
yes it will create a unique number everytime you execute your job.
-
- Premium Member
- Posts: 50
- Joined: Tue Jan 02, 2007 1:40 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.
Last edited by chulett on Tue Jul 03, 2007 7:46 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Unique Sequence Number
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....??