Unload a select no. of rows from a table
--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--
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