Is there any comprehensive source of information regarding the parsing of XML from RPG using DB2 parsing functions and how to handle special characters?
For example, a superscript 2 (or "squared") is html entity code ² (unicode 00B2). This must be a valid EBCDIC value because I can see it in one of our tables in a char field (CCSID 37). When the xml file contains ² (because the & symbol has to also be escaped), I would expect it to also translate to the proper EBCDIC value, but it doesn't, it retains the string ².
Is there some documentation I can read through that will outline what characters are valid and what html entity codes (unicode values) can be parsed and properly translated by DB2 XML functions?
Other symbols include: ®, é, double quotes (".
Not sure if this matters, but the files are being parsed directly off a network location mounted via /QNTC on the iSeries, and the CCSID of the files is 1252.
For example, a superscript 2 (or "squared") is html entity code ² (unicode 00B2). This must be a valid EBCDIC value because I can see it in one of our tables in a char field (CCSID 37). When the xml file contains ² (because the & symbol has to also be escaped), I would expect it to also translate to the proper EBCDIC value, but it doesn't, it retains the string ².
Is there some documentation I can read through that will outline what characters are valid and what html entity codes (unicode values) can be parsed and properly translated by DB2 XML functions?
Other symbols include: ®, é, double quotes (".
Not sure if this matters, but the files are being parsed directly off a network location mounted via /QNTC on the iSeries, and the CCSID of the files is 1252.
Comment