How to use KeyMgtGetNextValue routine

nkln@you · Post by **nkln@you** » Mon Dec 13, 2004 6:09 am

How to use the routine KeyMgtGetNextValue, for getting the surrogate key from a Hash file created by the user.

i.e if i want to get the number of rows in a hash file, can i use this routine.

And also how this routine works.
Thanks in advance for your suggestion.

WoMaWil · Post by **WoMaWil** » Mon Dec 13, 2004 6:20 am

with the KeyMgtGetNextValue you can generate Numbers, each time you call this function you get a number one number higher. Every key has to have a name. If you call your number Jack, each time calling Jack with this routine you get one more. There are functions to set Jack back to zero, You can have as much counters as you want, each has to have an other name.

For to get the numbers of rows in a hash-file there are other functions. You can set up for example a "select count(*) from HashfileName" for to get the number.

peternolan9 · Post by **peternolan9** » Mon Dec 13, 2004 8:42 am

Hi nkln@you,
please be aware that the performance of this routine is terrible and should be avoided if your volumes are above nominal.

I think someone else posted a routine.....we had one developed and I believe the client owns it so I wouldn't post it here.

nkln@you wrote:How to use the routine KeyMgtGetNextValue, for getting the surrogate key from a Hash file created by the user.

i.e if i want to get the number of rows in a hash file, can i use this routine.

And also how this routine works.
Thanks in advance for your suggestion.

vinaymanchinila · Post by **vinaymanchinila** » Thu Sep 29, 2005 1:50 pm

I need to start the key generation at a particular number, in this case is changing (Copy) the routine the best way to do this, I did read it before but I am not sure where !
Thanks,

pavanns · Post by **pavanns** » Thu Sep 29, 2005 3:34 pm

you can generate a new set of keys for all teh attributes of the colum specified and they keep changing each time you run ...key managment features basically done in the transformer stage and can be set to any value...and a routine can be designed for a generation of a user defined key

vinaymanchinila · Post by **vinaymanchinila** » Thu Sep 29, 2005 3:50 pm

there is alreadya routine present !

pavanns · Post by **pavanns** » Thu Sep 29, 2005 3:54 pm

ru looking for teh location of the routine ?

vinaymanchinila · Post by **vinaymanchinila** » Thu Sep 29, 2005 4:00 pm

dude,
I know where it is, I wanted to figure out if changing the routine is the best way to go or we do have a function !

DSXchange

How to use KeyMgtGetNextValue routine

How to use KeyMgtGetNextValue routine

Re: How to use KeyMgtGetNextValue routine