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.sysdummy1
when I run this sql statement in db throwing an exception
Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LC_CTYPE;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_CTYPE|ELECT CURRENT LOCALE|<space>, DRIVER=3.50.152
SQLState: 56098
ErrorCode: -727
Any help is appreciated.