DSXchange

Hi ,

Can we ger row count in hash file.can i know how can we do that?

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.

DSLinkRowCount sometimes gives wrong values. I am not sure why this happens. So just check before using it.

hemachandra can you please give some instances when you got wrong values? I used it quite frequently. It will help me further

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.

When extractying data from Sybase database to a flat file, the count was wrong.

... and what has that to do with the topic of this thread?!! Please do not hijack other people's threads - start a new one when the topic is different.