Informix SE and dbexport

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

In message <1147375580.982961.12000@q12g2000cwa.googlegroups.com>, Carson Douglas <c320f@yahoo.com> writes >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 > The date format is held in an internal format (as an unsigned integer I believe) - MM/DD/YYYY is simply the ASCII representation of it, and you can influence what it unloads as with the DBDATE shell variable. So, can you do a straight unload of the table? If that also stops, it will probably be at the row with the corrupt value. You could include the rowid in the unload, as a help to working out where the problem is. Once you have found the rowid for the corrupt row you can hopefully correct it via SQL. You can just move the whole database (the .dbs directory and it's contents) to a new location (but remember the systables entries for the log file will need fixing), but not being able to dbexport it is a sign of Something Nasty in the Database which needs correcting whatever you do, as it will generate errors if you try to access that row. Also, if you move the .dbs directory & it's contents make sure you leave the correct permissions on the stuff after you have moved it, and remember to check systables for any tables no in the main .dbs directory. -- Surfer! Email to: ramwater at uk2 dot net

Hi, Check that the $DBDATE is the same on the receiving database as it is on the primary. Rick Carson Douglas wrote: > 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 >