i have created two db's on two servers with same command
db2 create db sample on f: using codeset ibm-1252 territory gb

now when i run db2 values char(current date)
one gives 10/12/2007
and other 12/10/2007

even the regional settings on control panel are same for both.
what can be the probable reason and solution.

i can not change the code(char(sdf,iso) etc ) as the application is
already live and too huge

rahul wrote:
pretty print from the client. So investigate that end.
(territory of the shell that started CLP, etc, etc...)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab