Oninit cdi / Archive
Talk to an expert →

Resolution on dbexport is wrong

Posted in 2001

Topics: Migration, Import/Export & Data Conversion, Internationalization & Character Sets

tlka — — source: Informix-list mailing list archive (1991-1998)

I use Informix Online 7.22 UC3 on SCO OS 5.0.4. After transfer from NLS to GLS an dbexport ´dbname´ -ss bring on statistics update a resolution 050000. But it must be 0.50000. What is wrong? Can anyone help me, Please ? Thanks, jush

↪ replying to tlka
Helmut Leininger — — source: Informix-list mailing list archive (1991-1998)

tlka wrote: > I use Informix Online 7.22 UC3 on SCO OS 5.0.4. After transfer from NLS > to GLS an dbexport ´dbname´ -ss bring on statistics update a resolution > 050000. But it must be 0.50000. What is wrong? > Can anyone help me, Please ? > Thanks, > > jush Language settings include also the decimal delimiter, i.e. it depends on the language. Probably your settings between NLS and GLS are different. Solution: before running dbimport you should set DBMONEY and DBDATE to values compatible with the settings at dbexport time. Regards -- Helmut Leininger Bull AG / Vienna Open Systems Support Email: h.leininger@bull.at This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.

Glossary