RE: 0 row(s) unloaded

Posted in 2005

Dirk Moolman — Wed, 17 Aug 2005 08:14:46 +0200 — source: Usenet: comp.databases.informix

Great, thank you very much for the feedback, I do appreciate it. I don't think I will require a patch for this, as we do not depend on this result from dbacces - and it is the first time I ran into this. Was able to work around it the old fashioned way. Thanks again for the feedback. Regards Dirk ________________________________________ From: Fnu Gaurav [mailto:fnug@us.ibm.com] Sent: 16 August 2005 07:22 PM To: Dirk Moolman Cc: informix-list@iiug.org; owner-informix-list@iiug.org Subject: RE: 0 row(s) unloaded PTS#171822 LOAD DISPLAYS INCORRECT/FEWER THAN EXPECTED NUMBER OF ROWS LOADED, HOWEVER SELECT COUNT (*) CONFIRMS THAT NUMBER OF ROWS LOADED IS CORRECT/EXPECTED But sorry to say that it is fixed in 9 families only. The cause of this was the engine flushing the count before sending to client in some cases. I think you are hitting the same thing. You can request it for 7x through TechSupport. Thanks and Regards, Gaurav "Dirk Moolman" <DirkM@caretech.co.za> "Dirk Moolman" <DirkM@caretech.co.za> Sent by: owner-informix-list@iiug.org 08/16/2005 10:05 AM To Fnu Gaurav/Lenexa/IBM@IBMUS cc <informix-list@iiug.org> Subject RE: 0 row(s) unloaded "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 sending to informix-list