Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
--openmail-part-03f3c50c-00000002
Content-Type: text/plain; charset=ISO-8859-1; name="BDY.RTF"
Content-Disposition: inline; filename="BDY.RTF"
Content-Transfer-Encoding: 8bit
Hi,
I am faced with a peculiar problem and hence need some help.
I have a table that is 6GB in size. A full unload of the table will lead
to a flat file of about 4GB. The problem is that I cannot take an unload
of this table since informix cannot handle files greater than 2GB. Is
there anyway i can unload say in bunches of 10000 rowsand then continue
like that till the entire table is unloaded. I use Informix 5.10
Thanks once again folks
Regards
Jinu
--openmail-part-03f3c50c-00000002
Content-Type: application/rtf; name="BDY.RTF"
Content-Disposition: attachment; filename="BDY.RTF"
Content-Transfer-Encoding: base64
e1xydGYxXGFuc2lcYW5zaWNwZzEyNTBcZGVmZjBcZGVmbGFuZzEwNDV7XGZvbnR0Ymwge1xm
MFxmc3dpc3NcZmNoYXJzZXQwIEFyaWFsO317XGYxXGZzd2lzc1xmY2hhcnNldDIzOHtcKlxm
bmFtZSBBcmlhbDt9QXJpYWwgQ0U7fX0NClx1YzFccGFyZFxsYW5nMTAzM1x1bG5vbmVcZjBc
ZnMyMCBIaSxccGFyDQpJIGFtIGZhY2VkIHdpdGggYSBwZWN1bGlhciBwcm9ibGVtIGFuZCBo
ZW5jZSBuZWVkIHNvbWUgaGVscC5ccGFyDQpccGFyDQpJIGhhdmUgYSB0YWJsZSB0aGF0IGlz
IDZHQiBpbiBzaXplLiBBIGZ1bGwgdW5sb2FkIG9mIHRoZSB0YWJsZSB3aWxsIGxlYWQgdG8g
YSBmbGF0IGZpbGUgb2YgYWJvdXQgNEdCLiBUaGUgcHJvYmxlbSBpcyB0aGF0IEkgY2Fubm90
IHRha2UgYW4gdW5sb2FkIG9mIHRoaXMgdGFibGUgc2luY2UgaW5mb3JtaXggY2Fubm90IGhh
bmRsZSBmaWxlcyBncmVhdGVyIHRoYW4gMkdCLiBJcyB0aGVyZSBhbnl3YXkgaSBjYW4gdW5s
b2FkIHNheSBpbiBidW5jaGVzIG9mIDEwMDAwIHJvd3NhbmQgdGhlbiBjb250aW51ZSBsaWtl
IHRoYXQgdGlsbCB0aGUgZW50aXJlIHRhYmxlIGlzIHVubG9hZGVkLiBJIHVzZSBJbmZvcm1p
eCA1LjEwXHBhcg0KVGhhbmtzIG9uY2UgYWdhaW4gZm9sa3NccGFyDQpSZWdhcmRzXHBhcg0K
SmludVxsYW5nMTA0NVxmMVxwYXINCn0NCgA=
--openmail-part-03f3c50c-00000002--
↪ replying to Jinu.Joseph@citicorp.com
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
First please do not post MIME to this newsgroup.
Jinu.Joseph@citicorp.com wrote:
>
> Hi,
> I am faced with a peculiar problem and hence need some help.
>
> I have a table that is 6GB in size. A full unload of the table will lead
> to a flat file of about 4GB. The problem is that I cannot take an unload
> of this table since informix cannot handle files greater than 2GB. Is
> there anyway i can unload say in bunches of 10000 rowsand then continue
> like that till the entire table is unloaded. I use Informix 5.10
Get my dbexport/dbimport replacement utility. You will need to modify the
myexport script to include the -5 flag to myschema but if your OS can handle
large files myexport and myimport can also.
Art S. Kagel
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.