Kbase P60396: Is possible to ascii dump file bigger than 2 GB from 4GL ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/4/2010 |
|
Status: Verified
GOAL:
Is possible to ascii dump file bigger than 2 GB from 4GL ?
GOAL:
Is possible to access ascii file bigger than 2 GB from 4GL ?
FACT(s) (Environment):
Progress 9.1C 64-bit
Progress 9.1D 64-bit
Progress 9.1E 64-bit
FIX:
Yes, with Progress 64-bit product is possible to dump / access files bigger than 2 gigabytes from 4GL by using the STREAM option:
For example, if running 64bit version of Progress and the filesystem supports it as well as ulimt -f:
def stream s_out.output stream s_out to /path/file.for each table no-lock:export stream s_out table.end.output stream s_out close.
Importing a >2GB file however will fail because the lseek position is still 32-bit limited and therefore fails. Typically (not exclusively) with error messages:
** Array subscript 11 out of range (26)
** Unable to update Field (142)
Alternatively, upgrade to OpenEdge 10.1C+ where a feature enhancement was introduced to allow LBI, SRT, INPUT FROM and OUTPUT TO files to grow larger than 2gig.