Getting Row count for all hash files in a category
Moderators: chulett, rschirm, roy
Getting Row count for all hash files in a category
I want to know how to get rowcount for all the hash files in a prticular category or in a project.
For getting rowcount for a single Hashfile we are using
"Select Count(*) from HashFileName", is there some thing like this to get the count for all the Hashfiles used in a category.
Rgds
Andal.
For getting rowcount for a single Hashfile we are using
"Select Count(*) from HashFileName", is there some thing like this to get the count for all the Hashfiles used in a category.
Rgds
Andal.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There isn't.
You could create a job sequence to identify the hashed files then run a job to count the records in each, appending the results to a file or inserting into a database.
Do you want to include all the hashed files that make up the repository?
Is there a standard location for your hashed files? That would affect the mechanism you choose for identifying the hashed files.
You could create a job sequence to identify the hashed files then run a job to count the records in each, appending the results to a file or inserting into a database.
Do you want to include all the hashed files that make up the repository?
Is there a standard location for your hashed files? That would affect the mechanism you choose for identifying the hashed files.
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.
My hash files are in the same folder where my project lies, we will categorize the hash files by functional wise, ex for Finance related jobs we will be having a category like Finance_Intial_Load, and for purchase we are having Purchase_intial_Load.
I am having the list of hash files used in each category , but how can i use them as a parameter and loop the job.
I am having the list of hash files used in each category , but how can i use them as a parameter and loop the job.
Code: Select all
select
EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '35L',
DS_JOBS.NAME AS JOB_NAME FMT '35L',
DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L'
from
DS_JOBOBJECTS,
DS_JOBS
where
DS_JOBOBJECTS.OLETYPE in ('CHashedOutput','CHashedInput')
and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO
group by
FILE_NAME,
JOB_NAME,
LINK_NAME
;
Code: Select all
select
CATEGORY,
COUNT(*)
from
DS_JOBOBJECTS,
DS_JOBS
where
DS_JOBOBJECTS.OLETYPE in ('CHashedOutput','CHashedInput')
and EVAL DS_JOBOBJECTS."@RECORD<6>" <> ''
and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO
group by
CATEGORY
;
Mamu Kim
Hi All
Thanks for ur suggestions, The query given by Kim returns me entire rowcount of a category which doesnt satisfy my requirement.
So i looped a sequence and passed the Hashfile name as a input to my server job, and i got my required output. Thanks for all for spending ur valuable time.
Rgds
Andal
Thanks for ur suggestions, The query given by Kim returns me entire rowcount of a category which doesnt satisfy my requirement.
So i looped a sequence and passed the Hashfile name as a input to my server job, and i got my required output. Thanks for all for spending ur valuable time.
Rgds
Andal
The query given by kim will return all the Hash file names.Loop it and then useTitto wrote:Can you post the code please
Code: Select all
SELECT Count(*), '#HashName#' FROM #HashName#;
My approach at that time was different. any how if you want the code, tell me ur mail id. I will send u the dsx.
Rgds
Anand
Anand
i too need
hi Andal
i too need the code , could u plz send it to kkreddy29@gmail.com
thanks and regards
Kiran Kumar
i too need the code , could u plz send it to kkreddy29@gmail.com
thanks and regards
Kiran Kumar
Please send it to raj_titto@yahoo.comAndal wrote:The query given by kim will return all the Hash file names.Loop it and then useTitto wrote:Can you post the code pleaseand write it to a Sequential file.Code: Select all
SELECT Count(*), '#HashName#' FROM #HashName#;
My approach at that time was different. any how if you want the code, tell me ur mail id. I will send u the dsx.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: