RE: Splitting a big file into smaller files

If you do the following command
Dspfd filename
And page to the bottom
You should see something like
Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 5390
Total deleted records . . . . . . . . . . : 0
Total of member sizes . . . . . . . . . . : 3354624

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Friday, April 17, 2015 4:58 PM
To: Midrange Systems Technical Discussion
Subject: RE: Splitting a big file into smaller files

Deleted records?


Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Darryl Freinkel
Sent: Friday, April 17, 2015 4:56 PM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Splitting a big file into smaller files

I am splitting large files of 400,000 plus records into files of 10,000 each.



I am using SQL to create the records using the create table command. I split the file using

FROM RRN(A) between 1 and 10,000

FROM RRN(A) between 10,001 and 20,000

FROM RRN(A) between 20,001 and 30,000

.



Problem:

Why would the system not copy exactly 10,000 records. I have several files that have a few records less than the 10,000 I should have in each file.



Has anyone seen this problem before?

If you have, what is the reason?



This is a V5R4 system.



TIA



Darryl Freinkel

Assignment 400 Group, Inc.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.