zOs/SQL/LOCALE
set current locale lc_ctype = '' ;
select substr( current locale lc_ctype, 1, 12), current date
, upper('abcdef aäâà eéèêë iïî oöôò uüûù +ABÄÖÜ') "upper"
, translate(upper('abcäöü+ABÄÖÜ'), 'ÄÖÜ', 'äöü') "translate(upper"
from sysibm.sysdummy1;
set current locale lc_ctype = 'De_CH' ;
select substr( current locale lc_ctype, 1, 12), current date
, upper('abcdef aäâà eéèêë iïî oöôò uüûù +ABÄÖÜ') "upper"
, translate(upper('abcäöü+ABÄÖÜ'), 'ÄÖÜ', 'äöü') "translate(upper"
from sysibm.sysdummy1;