setting KeyMgtGetNextValue / KeyMgtGetNextValueConcurrent

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
abha.kalra
Participant
Posts: 37
Joined: Fri Oct 21, 2005 4:09 am

setting KeyMgtGetNextValue / KeyMgtGetNextValueConcurrent

Post by abha.kalra »

Can KeyMgtGetNextValue / KeyMgtGetNextValueConcurrent be set with a negative value.

My job requires to generate -ve number when ever the id is not present in source.
Thanks and Regards
Abha
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You can certainly copy them and change or enhance them any way you like. However, I have no idea what "generate -ve number" means, never mind the fact that it sounds like something you should handle in your job, not in the routine call. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
DS_SUPPORT
Premium Member
Premium Member
Posts: 232
Joined: Fri Aug 04, 2006 1:20 am
Location: Bangalore

Post by DS_SUPPORT »

It seems, your requirement is just lookup validation. If a lookup fails, you wanted a negative number sent to the target.

If this is you requirement, just create a simple routine which will return some Negative value, and whenever the lookup fails, call the routine and fetch the value. So that it will be generalized and in future also, if needed you can change your return value.
Post Reply