[progress Communities] [progress Openedge Abl] Forum Post: Read Clob From Xml Into Dataset...

[Johan Vergeer]

Hi everyone, I'm trying to read some CLOB / LONGCHAR data from an XML file into a temp-table. 1 SHIPLABEL ZPL false CgpeRlggU2hpcG1lbnQgSUQgICAgIDogJ DEF TEMP-TABLE ttLabel NO-UNDO XML-NODE-NAME "label" FIELD labelID AS INT XML-NODE-TYPE "ATTRIBUTE" FIELD labelType AS CHAR XML-NODE-TYPE "ATTRIBUTE" FIELD labelFormat AS CHAR XML-NODE-TYPE "ATTRIBUTE" FIELD supplementaryLabel AS LOGICAL XML-NODE-TYPE "ATTRIBUTE" FIELD labelContent AS CLOB XML-NODE-TYPE "TEXT" XML-DATA-TYPE "base64Binary" COLUMN-CODEPAGE "UTF-8". Now the file is read into the temp-table TEMP-TABL ttMessage:READ-XML ("FILE", cMessage, "EMPTY", ?, ?, ?, "IGNORE"). The result for ttMessage.labelContent is a file named labelContent!UTF-8!1148_1.blb. This file only contains one return. How can I read the contents of the base64 file from the XML using a TEMP-TABLE?

Continue reading...