Re: Splitting a big file into smaller files

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

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.