By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,254 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Migration problem due to decimal separator keeping being COMMA instead of PERIOD

P: n/a
Dear all,

In a version 7 Workgroup Edition FP6 on Windows, a values decimal('7.5',9,2)
is correctly displayed as '7.5'. Applying FP10 or FP11 displays as '7,5' in
the output grid of command center.
Server settings are:
For W2K French, Regional settings=France, Decimal separators is '.'.
For DB, codepage 1252, country 33.

The pb is on version 8, I cannot get a '7.5' displayed in the command
center. Whatever I do, changing the regional settings to US_EN, setting
PATCH2=15 in the db2cli.ini, I cannot change the behavior.

This is a very important pb because my customer cannot migrate to version 8,
due to this phenomena that breaks its application.

Do you have any clue for this pb ?

Thanks for your help,

Jean-Marc

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Backstage" suggests that you should try Setting the DEFAULT locale in
Regional Settings in Windows.
Supposedly thre was a bug In CC in V7 which has been fixed. You may
have, unwittingly, exploited the defect.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
Hi Serge,

It seems to me that the command center output grid (CLI) does not pick the
regional settings as well as the cli PATCH2=15. I have tested with Excel or
QTOdbc, and the behavior is fine (V8.1 and Stinger). I've just made a post
for the command center on Stinger.

Thanks for your help,

JM

"Serge Rielau" <sr*****@ca.eye-be-em.com> a écrit dans le message de
news:ca**********@hanover.torolab.ibm.com...
"Backstage" suggests that you should try Setting the DEFAULT locale in
Regional Settings in Windows.
Supposedly thre was a bug In CC in V7 which has been fixed. You may
have, unwittingly, exploited the defect.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.