IMB i Access 7.1

----------------

아래 xml에 한글이 포함되면 쿼리가 안되는데 무슨 문제일까요?

 SELECT 

    X.DEP_ID

FROM (

    SELECT XMLPARSE (DOCUMENT '<root><row><DEP_ID>한글</DEP_ID></row><row><DEP_ID>1000000005</DEP_ID></row></root>') AS ELEMENT_VALUE

FROM SYSIBM.SYSDUMMY1

) AS A

, XMLTABLE 

(

'$d/root/row' PASSING Element_value AS "d"

COLUMNS 

DEP_ID  VARCHAR (10)  PATH 'DEP_ID'

) AS X;