Re: DBEXPORT with 4.11 ---> DBIMPORT with 5.01

> Hi there, > > can anybody help me with my problem? > > I have exported a database using DBEXPORT on a 4.11 Informix Online DB. > ThanI tried to import it on a machine running 5.01 and get an error 1226. > Difficulties at exporting or file transfer are out of the question. > > Is this a known problem? > What should I do except editing the unload files or something like that? > > Any help? > > Peter > I see -1226 is "decimal value exceeds maximum precision". It's probably a long shot, but I once had a problem with a database which had long CHAR type columns. The users had put newline characters in the data, which dbexport (4.xx) incorrectly stored with the same character as the column delimiter. (5.00-on correctly uses CONTROL-N). Thus, dbimport couldn't make any sense of the exported data - I just got "no. of values not equal to no. of columns". Perhaps in your case this is happening and dbimport is trying to put the wrong value into the decimal column. Just a wild guess, but who knows. If this *is* what it is, try setting DBDELIMITER to something else (TAB for example) and see if that works. akent@cix.compulink.co.uk (Andy Kent) -------------------------------------