Re: Splitting a big file into smaller files

Hi Darryl,

-- You might find this useful to see if there is any difference with what
you are expecting:

with t1 as (

select row_number() over(order by RRN(a) ) as row_number, RRN(a) as RRN, a.*

from table-name a)

select *

from t1

where row_number <> RRN ;


-- This statement will select exactly 10,000 rows provided there are 10,000
rows in the table:

-- You could create the new tables with the extra row_number column and
then alter the tables and drop the column.


with t1 as (

select row_number() over(order by RRN(a) ) as row_number, a.*

from table-name a)

select *

from t1

where row_number between 1 and 10000 ;




Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144

Please consider sponsoring me for one of the charity bike rides I am
participating in:
Friends For Life Bike Rally
<https://secure.e2rm.com/registrant/FundraisingPage.aspx?SID=5323935&LangPref=en-CA>
in support of the Toronto People with AIDS Foundation
Cycle For Sight
<https://secure.e2rm.com/registrant/FundraisingPage.aspx?registrationID=2658720&langPref=en-CA>
in support of the Foundation Fighting Blindness


On 17 April 2015 at 16:55, Darryl Freinkel <dfreinkel@xxxxxxxxxxxxxxxxx>
wrote:

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.