Record Count of Hashed File
Moderators: chulett, rschirm, roy
Record Count of Hashed File
Is there any way that we can get the record count of a hashed file?
I do realize that we can write it to a sequential file and then get the count.
When it comes to datasets, we are able to use the orchadmin commands to get the count. Similarly, is there any way to get the record count of a hashed file?
Thanks!
I do realize that we can write it to a sequential file and then get the count.
When it comes to datasets, we are able to use the orchadmin commands to get the count. Similarly, is there any way to get the record count of a hashed file?
Thanks!
Joel Satire
-
- Premium Member
- Posts: 112
- Joined: Mon Jul 11, 2005 7:54 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the Administrator client select your project and click the Command button. This opens a dialog in which you can enter "TCL commands" in the project. It's here that you enter the SETFILE command and the COUNT command.
Code: Select all
SETFILE pathname_of_hashed_file name_of_hashed_file
COUNT name_of_hashed_file
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.
Re: Record Count of Hashed File
You can use ajoesat wrote:Is there any way that we can get the record count of a hashed file?
I do realize that we can write it to a sequential file and then get the count.
When it comes to datasets, we are able to use the orchadmin commands to get the count. Similarly, is there any way to get the record count of a hashed file?
Thanks!
InputHash----->Transformer------->OutputHashFile
In transformer stage you can use stage vaiable for the count and load back the same data to other hash file.
Else you can use a aggregator stage with a function count instead of stage variable.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No.joesat wrote:your message got cutoff, Ray... i know i have to subscribe, alas my heart is willing but my purse is weak
can you display the post in full please?
Premium membership is one of the ways that the hosting and bandwidth costs incurred by DSXchange are met. You will note that there is no advertising. I do not intend to create a precedent whereby the very survival of DSXchange is put at risk.
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.
Thanks monaz.. but I want to get the count without creating a new DS job and just by executing some commands or a shell script... this is because we need to get the count of some hashed files every month without using ETL jobs and just Shell scripts...
For the file counts and datasets, we can get the data from links, wc and orchadmin commands.. count of hashed files has been elusive so far...
For the file counts and datasets, we can get the data from links, wc and orchadmin commands.. count of hashed files has been elusive so far...
Joel Satire
Not so elusive, what you need has been posted in this thread more than once: SETFILE and COUNT. Search the forums for SETFILE, its syntax and usage *are* out there. For scripting help, search the forums for dssh which is where the commands would be run outside of the Adminstrator GUI.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers