Re: Dbexport / Dbimport Utility

Hi Sweeney: It might be mismatch for no. of records in dbimport script and no. of records in ASCII unl file for that table. If mismatches, you can change in dbimport SQL script and run dbimport command again. Ravi Yarlagadda Informix Certified Professional -----Original Message----- From: Tracy Sweeney [mailto:SWEENTRA@pentamation.com] Sent: Thursday, December 16, 1999 9:15 AM To: informix-list@iiug.org Subject: Re: Dbexport / Dbimport Utility Have you tried running the oncheck/bcheck utility against the table(s) to ensure that you do not have corrupt indexes? Try an update statistics through sql first also. >>> "Lloyd AJ Wilson" <lwilson@harriscomputer.com> 12/15/99 4:55:26 PM >>> 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.