Re: Date Conversion Error 1218

KENDRICKS CHERYL wrote: > I did an dbexport on a database using INFORMIX-OnLine Version > 7.23.UC4. > > When I attempted to dbimport the database I receive the following > error: > > -1218 String to date conversion error. > > The input to the rstrdate() function does not properly represent a > date: either it has nondigits where digits are expected, an unexpected > > delimiter, or numbers that are too large or are inconsistent. > > Does anyone have an idea of what could actually be causing this > problem? > The date data in the > columns specified as date column look fine? > > TIA > Cheryl L. Kendricks > Sr. DBA H.E. Butts Grocery > San Antonio, Texas There are two things that could possibly be causing you problems.1) There could be data integrety problems with the dump. Some thing you can do is in your export sql code do a global search for all date and time columns and from there do some data integrety searchs in those tables using these columns. 2) The Informix utility dbimport is a very picky utility and can not be trusted. Even though the manuals say some items may be optional like buffering preferences and dbspace specifications these should always be used allong with any other parameter and element your dbimport can use with the database. I have been burned twice not using all the optional elements with dbimport with my database. Good luck! The dbexport and import utilities are tricker than you would expect. Steven Hronek