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