MVSFORUMS.com

wolves · Beginner Joined: 11 Jun 2004 Posts: 17 Topics: 8

While in 3.4, I am looking at a very large file with over 1M records. Instead of just going to the bottom to see how many records I have, it takes awhile, is there a command to count how many records?

kolusu · Posted: Fri Jun 25, 2004 9:52 am Post subject:

wolves,

Please search before posting. This topic has been covered earlier. Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=7&highlight=count

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Mervyn · Posted: Mon Jun 28, 2004 3:37 am Post subject:

If you are in Edit or View (but not Browse) this Edit macro may be useful:

slade · Posted: Thu Jul 01, 2004 2:07 pm Post subject:

In edit or view you could also try:

L .ZL

Regards, Jack.

veluvpv · Beginner Joined: 14 Jul 2008 Posts: 9 Topics: 1

Using File-Aid Tool in Option 3 -Utiltilities in that option 8-Interactive mention the input dataset and then enter and give the command Tally. It will display number records read in the input file.

Regards,
Velu

Bill Dennis · Posted: Thu Jul 17, 2008 7:55 am Post subject:

if someone has the region to edit/view a million line file, i'd be amazed!
_________________
Regards,
Bill Dennis

Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity.

sivafdms · Intermediate Joined: 29 May 2007 Posts: 165 Topics: 77

Mervyn,

When i tried to count the no of lines in file it is giving following message

dbzTHEdinosauer · Posted: Tue Feb 10, 2009 9:57 am Post subject:

Siva,

were you actually in an edit/view session with the file, or did you just enter the name of the macro next to the DSN in a 3.4 display?

The screen shot you gave indicates that you are not in a view/edit session with the ds.

large files should be dealt with by a batch job, especially if all you want is a count.

This is one of those things that rookie designers forget:
During the creation of a file is the time to count, not afterwards.
_________________
Dick Brenholtz
American living in Varel, Germany

sivafdms · Intermediate Joined: 29 May 2007 Posts: 165 Topics: 77

dbzTHEdinosauer

Even in edit/view this one is working.

Thanks,
Siva

Terry_Heinze · Posted: Tue Feb 10, 2009 9:13 pm Post subject:

I realize this is an old thread, but I've only just seen it now. Won't ISPF throw you into browse mode if you try to edit/view a very large file, in which case you can't run an edit macro?
_________________
....Terry

sivafdms · Intermediate Joined: 29 May 2007 Posts: 165 Topics: 77

Terry,

That's Correct .... But i tried to just test the macro on file which contains a few records.. i would like to know how we can test this macro..

Thanks,
Siva