Hashed file count

dodda · Post by **dodda** » Fri Dec 18, 2009 11:15 pm

Hi all,

Could anyone please let me know the Unix command to take the count for the Hashed file .

ray.wurlod · Post by **ray.wurlod** » Sat Dec 19, 2009 12:58 am

There isn't one.

In exactly the same way that there is no UNIX command for taking the count of an Oracle table.

A hashed file is how UniVerse database tables are implemented.

chulett · Post by **chulett** » Sat Dec 19, 2009 8:54 am

However, much like you can launch a sqlplus session and run a query from the command line, you can so something similar with 'dssh' as long as your hashed file is account-based.

dodda · Post by **dodda** » Sat Dec 19, 2009 11:45 pm

Thanks chullet for your reply

Kindly suggest the command to get the count for the Hased file after launching dssh.

chulett · Post by **chulett** » Sun Dec 20, 2009 8:23 am

Oddly enough... 'count'.

ray.wurlod · Post by **ray.wurlod** » Sun Dec 20, 2009 3:53 pm

Oh dear. Life is never that simple.

The actual command will differ depending on whether your hashed file is in the "account" (project) or a pathed hashed file, and you may need to perform further setup in the latter case. COUNT is a command from the RetrieVe query language; you may prefer to use SQL.

chulett · Post by **chulett** » Sun Dec 20, 2009 6:18 pm

Never said it would be simple or that was the only answer. And I did mention the need for an account-based hashed file. And yes, you may prefer to use SQL.