To find out no of records in production dataset

babujini · New User Joined: 14 Apr 2004 Posts: 7 Location: Chennai

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

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

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

babujini · New User Joined: 14 Apr 2004 Posts: 7 Location: Chennai

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

So please let me know,

Babu M

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

Hello babujini,

Did you tried the selection criteria option???

Regards
Mayuresh Tendulkar

babujini · New User Joined: 14 Apr 2004 Posts: 7 Location: Chennai

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

sandip_datta · Posted: Thu Apr 15, 2004 11:30 am

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.

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

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

sandip_datta · Posted: Thu Apr 15, 2004 11:40 am

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.

babujini · New User Joined: 14 Apr 2004 Posts: 7 Location: Chennai

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

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

Hello babujini,

Just try those options one by one...

Hope this helps,

Regards
Mayuresh Tendulkar

sandip_datta · Posted: Thu Apr 15, 2004 12:05 pm

Babujini,

try this...

MGIndaco · Posted: Wed May 18, 2005 5:26 pm

Why can't you try with a sort include or similar and browse the sysout of sort?

ashokreddy · New User Joined: 20 May 2005 Posts: 4 Location: india

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

pr_ibm · New User Joined: 04 May 2005 Posts: 9

Sorry Ashok,

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

regards
Pr...