|
As of version 17, DBISQL by default uses the machine's locale to display dates and numbers in the according locale, as stated here. For locales with comma as decimal separator, DBISQL uses the semicolon as default field separator. This works fine in my case with German locale. However, DBISQL 17.0.11.7236 does not accept numbers with a decimal comma as input (say, "0,75") for floating point or decimal data with the INPUT statement but raises a SQLCODE -151 error:
This somewhat does make it still difficult to import localized numbers. I suspect I still have to load those numbers into dummy string columns and then have to turn their values – swapping decimal comma to decimal point – into "real numbers". Am I missing a point (pun intended)? |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 05 Jan, 13:01
question was seen: 156 times
last updated: 05 Jan, 13:07