|
View previous topic :: View next topic
|
| Author |
Message |
parvezyunus
New User
Joined: 30 May 2006
Posts: 2
|
|
|
|
| How can you calculate average record length in a variable block file ? |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Do you mean the actual average of all records in the file or the record length that JCL or IDCAMS would expect to find ? |
|
| Back to top |
|
|
parvezyunus
New User
Joined: 30 May 2006
Posts: 2
|
|
|
|
| the actual average of all records in the file |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Use Sort to sum the lengths and count the recs and gen a trailer with the total lengths divided by the total count. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
If you run a sort, it will give you both the byte count and record count of the sorted data. If you divide, you get the average length. |
|
| Back to top |
|
|
|
|
