Hi ,
Can we ger row count in hash file.can i know how can we do that?
row count in hash file
Moderators: chulett, rschirm, roy
Re: row count in hash file
do you want a row count value in hash file or row count of hash file, depending on situation and requirement you need to apply furhter logic, but DSLinkRowCount can help you to know rowcount.
-
- Participant
- Posts: 27
- Joined: Wed Jan 03, 2007 1:29 am
Re: row count in hash file
DSLinkRowCount sometimes gives wrong values. I am not sure why this happens. So just check before using it.
Hemachandra
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are no rows in a hash file.
In a hashed file, however, there may be.
Set up a VOC pointer to the hashed file (search forum for SETFILE command) and use a query such as SELECT COUNT(*) FROM hashedfilename; to obtain the actual row count.
The link row count reports how many rows were sent but, if the key is an already-existing key on the hashed file a destructive overwrite occurs, which can mean fewer rows in the hashed file than were sent to it.
In a hashed file, however, there may be.
Set up a VOC pointer to the hashed file (search forum for SETFILE command) and use a query such as SELECT COUNT(*) FROM hashedfilename; to obtain the actual row count.
The link row count reports how many rows were sent but, if the key is an already-existing key on the hashed file a destructive overwrite occurs, which can mean fewer rows in the hashed file than were sent to it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 27
- Joined: Wed Jan 03, 2007 1:29 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: