Large Arev LH 2.5 Gigs, how fix FFE's? (AREV Specific)
At 14 SEP 1999 05:38:10PM Chuck Eder, Decision Support Solutions wrote:
I am hesitant to allow a table to exceed 2.5 Gigs but find myself between a rock and a hard place. If you can't dumplh, how do you fix frame format errors?
Chuck Eder
At 14 SEP 1999 11:23PM Steve Smith wrote:
You could use a good hex editor at DOS level, but you'd have to know exactly what you were doing.
Another option would be to mirror-post transactions into many smaller files, and reconstruct if necessary from the mirror records.
Big headache though - especially on resizes - slow on files of such size, in any language.
Steve
At 15 SEP 1999 12:07PM Dave Bennett wrote:
If you know the keys, (using another table) you can write a program to copy out the records to another file and apon the message do a programmed escape and call the routine again. You need to be modifiying the key list as you go. I have had good luck with this. Place the rev files on your local drive and resize the destination table.
At 15 SEP 1999 12:13PM Dave Bennett wrote:
I do have a program to get the keys, by reading through the rev file
using OSOPEN. But it takes forever. (100,000 records 3 hours last time I used it)