Last record in a hash file

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
gpbarsky
Participant
Posts: 160
Joined: Tue May 06, 2003 8:20 pm
Location: Argentina

Last record in a hash file

Post by gpbarsky »

Hi forumers.....

I need to acces the last record of a hashed file. Is there any formula I can apply ?

Besides, is there any way to count the quantity of records of a hashed file ?

Thanks in advance.
Guillermo P. Barsky
Buenos Aires - Argentina
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well, first off there's no such thing as the "last record" in a hashed file, any more than there is one in any other database table. Why do you ask? What are you trying to accomplish?

As to the count, for an account-based hashed file (i.e. one with a VOC record) you can use SQL to count anything needing counting. For pathed hashed files I don't remember the other syntax off the top of my head and don't have access to my notes right now. Perhaps someone else can chime in on that.

I think you just say "COUNT <filename>" but have no way to test it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply