× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2015

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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.