Kbase P6024: Decimal point shifts in imported data.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
When the data is imported, the decimal point shifts - e.g. .13 becomes 13.00, and 6.5 becomes 65.00.
Data was exported by a procedure in one session, and was imported into another database by another procedure run in a separate session.
Data exported to a .d file.
Data written to the .d file matches what appeared in the application.
CAUSE:
The data was being exported in a session started with AMERICAN numeric format, whereas it had been imported in a session started with -E (EUROPEAN) format. The EUROPEAN setting meant that the decimal point wasn't recognized as such when the data was imported.
FIX:
1. disp session:numeric-format can be used to check the session parameter.
2. Ensure that data exported from a session started with AMERICAN numeric format is also imported in a session started with AMERICAN format.
3. Check Shortcuts, .pf files etc. for references to -E.