RE: Dbexport / Dbimport Utility

LLoyd Looks like the export has some incorrect informstion. We have had similar (not identical) errors when the count of rows within the sql (this count is listed before the create table statement) and the rows in the unload file are different. Obtain a count of the number of rows in the file - the filename is listed with the create table. Change the count in the sql to match the actual rows in the table. That works for us Murray Wood -----Original Message----- From: Lloyd AJ Wilson [SMTP:lwilson@harriscomputer.com] Sent: Thursday, December 16, 1999 10:55 AM To: informix-list@iiug.org Subject: Dbexport / Dbimport Utility Has anyone a better utility then the dbexport / dbimport utilities that come with informix? If I run dbimport using redhat 6.1 IDS 2000 I keep getting Unknown error 0 Data Corrupt. But, if I run the same procedures ... in dbaccess such as create the table, load the data, create indexes ...etc ... it works! Not sure what is going on here ... considering I am working with an ASCII text export. If not I will make one ... for everyone ... and I will post it here ... give me a couple of weeks. Thanks in advance. Lloyd AJ Wilson.