Page 1 of 1
Hashed file count
Posted: Fri Dec 18, 2009 11:15 pm
by dodda
Hi all,
Could anyone please let me know the Unix command to take the count for the Hashed file .
Posted: Sat Dec 19, 2009 12:58 am
by ray.wurlod
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.
Posted: Sat Dec 19, 2009 8:54 am
by chulett
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.
Posted: Sat Dec 19, 2009 11:45 pm
by dodda
Thanks chullet for your reply
Kindly suggest the command to get the count for the Hased file after launching dssh.
Posted: Sun Dec 20, 2009 8:23 am
by chulett
Oddly enough... 'count'.
Posted: Sun Dec 20, 2009 3:53 pm
by ray.wurlod
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.
Posted: Sun Dec 20, 2009 6:18 pm
by chulett
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.
![Wink :wink:](./images/smilies/icon_wink.gif)