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.
How to use KeyMgtGetNextValue routine
Moderators: chulett, rschirm, roy
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.
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.
-
- Participant
- Posts: 214
- Joined: Mon Feb 23, 2004 2:10 am
- Location: Dublin, Ireland
- Contact:
Re: How to use KeyMgtGetNextValue routine
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.
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.
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am