File too large error message

Jeff Harrison Jeff.Harrison at Epixweb.com
Tue Mar 2 11:15:04 PST 2004


Bob Stockler wrote: 
> 
> On Tue, Mar 02, 2004 at 10:01:55AM -0600, Bill D Doyle wrote:
> [snip]
> | 
> | If I set the filesize to unlimited, will fP choke when the
> | filesize reaches 2GB?
> | I would like to avoid another problem before it happens.
> 
> It's claimed that filePro can support 1 billion records
> per file and that the key record length can be up to
> 32,700 bytes plus a 20-byte header, which implies that
> filePro can support a pretty large file.
> 
> If that's not large enough for you, you can always break
> the key segment into key+data records.  It's not too big
> a task to do this by overlaying the file with an alien
> file, then in an output process in it sequentially read
> each record in the file and use MID() to break thes into
> two parts, and WRITE() to write the parts to a "new.key"
> and a "data" file.
> 
> Bob

You can also have keyx1, keyx2, keyx3, and datax1, datax2 and datax3

Just create a blank keyx1 and datax1 file and filepro will automatically
start using those in addition to the key and data.

Jeff Harrison
jeff.harrison at epixweb.com

Author of JHExport and JHImport - The fastest and easiest ways to generate
code for filepro exports and imports.  Demos available upon request.


More information about the Filepro-list mailing list