Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
To find out no of records in production dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
babujini

New User


Joined: 14 Apr 2004
Posts: 7
Location: Chennai

PostPosted: Wed Apr 14, 2004 7:20 pm    Post subject:
Reply with quote

I have one production dataset.I has around 1 million records.I want to count the no of records which satisfy a particular condition for example SELECT RECORDS CONTAIN 'Y' AT POS 54.




Babu.M
Back to top
View user's profile Send private message

mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Thu Apr 15, 2004 9:10 am    Post subject:
Reply with quote

Hello

If your shot have FILE-AID you can use it to filter the records as per your criteria.

In option 1 of File-Aid.....Give the selection / Filter criteria as T and press Return key

It will prompt you for the selection criteria (Just select any of the 0 / 1 / 2 option) ...and provide the required selection criteria...you will get the desired records.

Hope this helps,

Regards
Mayuresh Tendulkar
Back to top
View user's profile Send private message
babujini

New User


Joined: 14 Apr 2004
Posts: 7
Location: Chennai

PostPosted: Thu Apr 15, 2004 9:50 am    Post subject:
Reply with quote

I tried with File-Aid . When we have large no of records, it shows insufficient memory.

So please let me know,

Babu M
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Thu Apr 15, 2004 11:11 am    Post subject:
Reply with quote

Hello babujini,

Did you tried the selection criteria option???

Regards
Mayuresh Tendulkar
Back to top
View user's profile Send private message
babujini

New User


Joined: 14 Apr 2004
Posts: 7
Location: Chennai

PostPosted: Thu Apr 15, 2004 11:28 am    Post subject:
Reply with quote

Yes Mayuresh,i tried with selection criteria. When i get larger no of records by the selection criteria, it shows insufficient memory.

Is there is any other way to find out the no of records?

Because i have no of datasets. So i don't want to submit jobs for every dataset.

Babu M
Back to top
View user's profile Send private message
sandip_datta

Active User


Joined: 02 Dec 2003
Posts: 151
Location: Tokyo, Japan

PostPosted: Thu Apr 15, 2004 11:30 am    Post subject:
Reply with quote

Hello babujini,
If u have browse authority in production file and it is sequential file open it with ISPF option 3.4. Issue F 'Y' 54 ALL. It will give you the number of records satisfying the criteria. Or you may use File Aid selection criteria as specified by Mayuresh.

Regards,
Sandip.
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Thu Apr 15, 2004 11:37 am    Post subject:
Reply with quote

Hello babujini,

Besides filtering the records...
I think you can also limit the output records you want to view.

So you can try that option too.

Hope this helps,

Regards
Mayuresh Tendulkar
Back to top
View user's profile Send private message
sandip_datta

Active User


Joined: 02 Dec 2003
Posts: 151
Location: Tokyo, Japan

PostPosted: Thu Apr 15, 2004 11:40 am    Post subject:
Reply with quote

But if you have no of files for investigation you better to run a batch job. It will atleast save some time than doing in online. But it depneds on your requirement obviously.

Regards,
Sandip.
Back to top
View user's profile Send private message
babujini

New User


Joined: 14 Apr 2004
Posts: 7
Location: Chennai

PostPosted: Thu Apr 15, 2004 11:41 am    Post subject:
Reply with quote

Hi Sandip,
Yes,i have browse authority .

I tried with selection criteria. When i get larger no of records by the selection criteria, it shows insufficient memory.

I have combinations of condition i.e Pos 54 'Y' and Pos 100 NE 'N', then how can i specify through F in 3.4?

Thanks,

Babu M
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Thu Apr 15, 2004 11:42 am    Post subject:
Reply with quote

Hello babujini,

Just try those options one by one...

Hope this helps,

Regards
Mayuresh Tendulkar
Back to top
View user's profile Send private message
sandip_datta

Active User


Joined: 02 Dec 2003
Posts: 151
Location: Tokyo, Japan

PostPosted: Thu Apr 15, 2004 12:05 pm    Post subject:
Reply with quote

Babujini,

try this...
Code:
X ALL;F 'Y' 45 ALL;DEL ALL X <ENTER>
Then enter again your second criteria with F command.


Regards,
Sandip.
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Wed May 18, 2005 5:26 pm    Post subject:
Reply with quote

Why can't you try with a sort include or similar and browse the sysout of sort?
Back to top
View user's profile Send private message
ashokreddy

New User


Joined: 20 May 2005
Posts: 4
Location: india

PostPosted: Fri May 20, 2005 1:17 pm    Post subject:
Reply with quote

hi babu,

i guess here you will stop asking the question next time about the no.of records.

GO TO OPTION 6
AND PRESS TSO LISTCAT ENT ('YOUR.DATASET.NAME') ALL

THE RESULT IS LIKE BELOW

TOTAL RECORDS = 84647,
WITH SOME OTHER INFORMATION
Back to top
View user's profile Send private message
pr_ibm

New User


Joined: 04 May 2005
Posts: 9

PostPosted: Wed Jun 01, 2005 3:59 pm    Post subject:
Reply with quote

Sorry Ashok,

I tried this option 6. It is displaying all the entries except number of records. can you please correct me ?


regards
Pr...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us