Does anyone have a SQL query that can successfully decode the XML fields in the LXC_INBOX_ENTRY table? We have been doing it using a linked server from SQL Server but would like to change this to a native DB2 for i query as there are issues with the linked server leaving connections hanging. It appears to be XML text stored in a BLOB column, but we just have not hit the right combination to properly display it. Parsing the XML gives us an error that the closing Envelope tag is incomplete,
Read more...even though we believe the XML is perfectly fine. Show less...
Jim Show less...
I can retrieve it in a program and move it to a variable that has a CCSID of 1208... then I can do pretty much anything with it... the only other thing I've ever done is copy the field and paste it into Read more...a "freeware" website that converts Hex to Text... In theory we could mod the table to change the CCSID of the blob.. then, in theory you'd be able to select cast(c_xml varchar(someLength) ccsid(37)) as XML from lxc_inbox_entry and get a valid result... Show less...