IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

To find out no of records in production dataset


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
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
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: 237
Location: USA

PostPosted: Thu Apr 15, 2004 9:10 am
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
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: 237
Location: USA

PostPosted: Thu Apr 15, 2004 11:11 am
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
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: 150
Location: Tokyo, Japan

PostPosted: Thu Apr 15, 2004 11:30 am
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: 237
Location: USA

PostPosted: Thu Apr 15, 2004 11:37 am
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: 150
Location: Tokyo, Japan

PostPosted: Thu Apr 15, 2004 11:40 am
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
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: 237
Location: USA

PostPosted: Thu Apr 15, 2004 11:42 am
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: 150
Location: Tokyo, Japan

PostPosted: Thu Apr 15, 2004 12:05 pm
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts Splitting group records based on deta... DFSORT/ICETOOL 8
No new posts Orphaned BCDS Records JCL & VSAM 1
No new posts Copy next subsquent records based on ... DFSORT/ICETOOL 5
No new posts Split Records based on length COBOL Programming 3
Search our Forums:

Back to Top