I believe the en_US is not supported in AIX5.*, but if you change the
value, LC_NUMERIC=En_US", which may have another code page instead of
819, you should be fine. Try that.
gr*****@chn.cognizant.com (Rajesh Gopinathan) wrote in message news:<88**************************@posting.google. com>...
Hi,
I have a locale problem in AIX 5.1
locale
LANG=pt_PT
LC_COLLATE="pt_PT"
LC_CTYPE="pt_PT"
LC_MONETARY="pt_PT"
LC_NUMERIC=en_US
LC_TIME=pt_PT
LC_MESSAGES=pt_PT
LC_ALL=
db2 "select some_decimal_field from some_table" returned say 51,000. Note that decimal separator is <comma>.
By changing LC_NUMERIC to en_US, I expected the decimal separator to
be <period> which is not what I got.
locale -ck decimal_point
LC_NUMERIC
decimal_point="."
DB2 settings are also correct
Database territory = US
Database code page = 819
Database code set = ISO8859-1
Database country/region code = 1
DB2 Version is 8.1
Where do you think is the problem..? with db2 or locale ? or with OS?