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

"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

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" <srielau@ca.eye-be-em.com> a écrit dans le message de
news:caa3oh$itc$1@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