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

[Jean-Marc Blaise]

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

[Serge Rielau]

"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

[Jean-Marc Blaise]

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