Re: Date Conversion Error 1218

ccremid wrote: > Check the DBDATE environment variable used at the time > of dbexport and see if its value matches the one that > you are using at the time of dbimport. > > <snip> > 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. > > <snip> This error is not always a result of a data error as mentioned by finderr 1218. We have seen this problem when Informix was used with other products. Ofcourse there was some problem always. Last time it was a memmory leak problem of one other product, which caused Iinformix to give a "Row fetch failed, Informix error - 1218" when that probudt was doing a SQL-Select from the database. -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com