how to change locale value in db2 by executing sql statement

**gouthami27** · Oct 25 '13, 01:45 PM

I tried to change the locale value in db2 environment, from 'en_us' to 'Fr_CA' using
SET CURRENT LOCALE LC_CTYPE = 'Fr_CA';
when I run this sql statement in db throwing an exception like 'Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LOCALE ;SET ;, DRIVER=3.50.152
SQLState: 42601
ErrorCode: -104'

and I tried to know the current locale using
SELECT CURRENT LOCALE LC_CTYPE FROM sysibm.sysdummy 1

when I run this sql statement in db throwing an exception

Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LC_CTY PE;ELECT CURRENT LOCALE;<space>, DRIVER=3.50.152
SQLState: 42601
ErrorCode: -104
Error: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;LC_CT YPE|ELECT CURRENT LOCALE|<space>, DRIVER=3.50.152
SQLState: 56098
ErrorCode: -727

Any help is appreciated.