How to deal with DBCS chars at IBMi db2

[owen-rpx]

XMLService how to parse DBCS (double-byte character set) chars?? Can u give us hint?

Below is our xml example:

<?xml version="1.0"?><xmlservice><myscript><sql><prepare stmt="main" error="fast"><![CDATA[SELECT TSKID, TSKNM, ENHTXT FROM DBNAMW.TK WHERE TSKNM = ?]]></prepare><execute stmt="main" error="fast"><parm><![CDATA[DEMO1]]></parm></execute><fetch stmt="main" block="all" desc="on" error="fast"></fetch><describe stmt="main"></describe><free></free></sql></myscript></xmlservice>

Thanks

[jimoibm]

Can you show me more on what you hit? the output/errors, the db field example, you job ccsid, and etc...