I have data in UTF-16 format soted in table . its is having some special characters(non english) . i have to implement upper case translation logic in sql query, that should translate both english as well as non enlish character to their upper case equivalent. i tried using the function upper-
select upper (<feild name>) from table.
the problem with the apporach is that it convert only english character, but non english character remain unchanged.
The data base iam using is DB2 V8 (ENFM) . and the its on Z/os( mainframe) system.
Could any suggest me how to implement, its urgent