Oninit cdi / Archive
Talk to an expert →

RE: 0 row(s) unloaded

Posted in 2005

Topics: Server Administration, Migration, Import/Export & Data Conversion

Dirk Moolman — — source: Usenet: comp.databases.informix

"Dirk Moolman" <DirkM@caretech.co.za> "Dirk Moolman" <DirkM@caretech.co.za> Sent by: owner-informix-list@iiug.org 08/16/2005 07:42 AM Just found a strange thing in dbaccess - first time I ever saw this. 'I am busy unloading tables, and after one of my unloads, it said: "0 row(s) unloaded." But, there is an actuall unload file, with rows in it ....... ' and a select count(*) on the table gives me the same number of rows as in theunload file - 919199 Weird sending to informix-list ________________________________________ From: Fnu Gaurav [mailto:fnug@us.ibm.com] Sent: 16 August 2005 05:01 PM To: Dirk Moolman Cc: informix-list@iiug.org; owner-informix-list@iiug.org Subject: Re: 0 row(s) unloaded what version ... Thanks and Regards, Gaurav "Dirk Moolman" <DirkM@caretech.co.za> DB-Access Version 7.31.FD3 Software Serial Number AAD#J293260 sending to informix-list

↪ replying to Dirk Moolman
Ramesh M via DBMonster.com — — source: Usenet: comp.databases.informix

Recently the same happened with me. Did you calculated the size of the file going to be? If not please do so. UNIX: 2GB limitation Dirk Moolman wrote: >"Dirk Moolman" <DirkM@caretech.co.za> > >"Dirk Moolman" <DirkM@caretech.co.za> >Sent by: owner-informix-list@iiug.org >08/16/2005 07:42 AM > >Just found a strange thing in dbaccess - first time I ever saw this. 'I >am busy unloading tables, and after one of my unloads, it said: > >"0 row(s) unloaded." > >But, there is an actuall unload file, with rows in it ....... ' and a >select count(*) on the table gives me the same number of rows as in the>unload file - 919199 > >Weird > >sending to informix-list > >________________________________________ >From: Fnu Gaurav [mailto:fnug@us.ibm.com] >Sent: 16 August 2005 05:01 PM >To: Dirk Moolman >Cc: informix-list@iiug.org; owner-informix-list@iiug.org >Subject: Re: 0 row(s) unloaded > >what version ... > >Thanks and Regards, >Gaurav > >"Dirk Moolman" <DirkM@caretech.co.za> > >DB-Access Version 7.31.FD3 >Software Serial Number AAD#J293260 > >sending to informix-list -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/informix/200508/1

Glossary