View previous topic :: View next topic
|
Author |
Message |
mosinjamadar
New User
Joined: 26 Sep 2007 Posts: 42 Location: pune
|
|
|
|
HI
I have huge flat files which I can open only in browse mode .Is there anyTSO or ISPF command to find out number of records in the file or right now i m doign M F8 which is taking lot of time because of browse mode and huge no of records
Please help
Thanks |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Use SORT in batch to get a record count. |
|
Back to top |
|
|
mosinjamadar
New User
Joined: 26 Sep 2007 Posts: 42 Location: pune
|
|
|
|
Hi,
Thanks for your response but .....
I dint get what do you mean by SOrt in batch could you please clrerify on that |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Submit a job that executes the SORT program and see the sysout for the record count. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
Back to top |
|
|
mosinjamadar
New User
Joined: 26 Sep 2007 Posts: 42 Location: pune
|
|
|
|
but Iwant to know is there any TSO or ISPF command to find number of records because I have 1000 huge flat files it wont be feasible for me to submit job for each and every file and check the count
Thanks in advance |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
to find the record count You will have to read all the records
doing from ISPF will be the worst performer
and will keep the tso session busy for a task that can be done better in some other way |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
and you better hurry, probably a different count tomorrow. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
mosinjamadar wrote: |
but Iwant to know is there any TSO or ISPF command to find number of records because I have 1000 huge flat files it wont be feasible for me to submit job for each and every file and check the count
Thanks in advance |
I will read that as "This looks like rather a lot of boring repetitive work"
Unfortunately a lot of areas in IT are like that, lots and lots of doing the same old thing day after day. Get used to it.
Maybe you should ask the programmers to write record counts to sysout from the programs rather than waste a lot of time and resource reading all of the files to find out later. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
find number of records because I have 1000 huge flat files it wont be feasible for me to submit job for each and every file and check the count |
Why do you believe you want/need exact record counts for 1000 files? There are few things with less value. . .
Suggest that with simple arithmetic you can get quite close to the number of records by calculating the number of records the used space will hold. |
|
Back to top |
|
|
|