DSXchange

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.

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.

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.

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,

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

there is alreadya routine present !

ru looking for teh location of the routine ?

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 !