Re: Informix SE and dbexport

Hi, An SE engine is just a bunch of files... if you're just wanting to change location, you can simply move the directory just like you would the contents of any other directory. You only need to use dbexport/dbimport when simply moving the directory doesn't work ;-) The date in the database doesn't have a format -- format of the date is a function of the client... part of GLS to be to precise. The "date" stored in the database is a number which represents the offset from some specific date. There are some other postings on how to find the rowid of a bad row, basically by elimination. With a date, I would think you can also get the job done by selecting the number representation and looking for what doesn't make sense, which I would think would be either a really large or small number (excluding whatever is used as a NULL value). For example, the stores7 demo database has the orders table, where order_date is a date column. select order_date::integer from orders where order_date is not NULL order by 1 asc; -- for what might be an early date problem select order_date::integer from orders where order_date is not NULL order by 1 des; -- for what might be a late date problem If that don't work... I guess you're stuck with narrowing down the rowid, which is basically selecting through the data until you find the bad row. "Carson Douglas" <c320f@yahoo.com> wrote in message news:1147375580.982961.12000@q12g2000cwa.googlegroups.com... > I'd like to move my Infomix 7.25 SE database to a new location, so I > tried to export it with dbexport, but I get this error: > > create table "ssf".fm_cost > ( > fmc_terminal integer, > fmc_vendor integer, > fmc_date date, > fmc_time char(5), > fmc_prodlnk integer, > fmc_cost decimal(8) > ); > revoke all on "ssf".fm_cost from "public";> > *** Error fetching data row. > > 1210 - Date could not be converted to month/day/year format > > > I guess this means there is a problem with one of the rows dates. How > can I find which row is causing the problem without doing a select * > from fm_cost and looking at each row. The date format in that table is > MM/DD/YYYY > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >

Thanks for the help I got it fixed. select trunc(fmc_date), rowid from fm_cost order by 1 asc The first row had a real large negative number in the fmc_date column. I had to remove it by rowid. Dbexport works now.