IBM Support

How to convert XML into String

Question & Answer


Question

How to convert XML into String

Answer

On Demand Consulting
Author: Volodymyr Sitarchuk

Here is the ESQL code to convert XML into String

DECLARE xmlAsBlob BLOB ASBITSTREAM(InputRoot.XMLNSC CCSID 1208);
DECLARE xmlAsChar CHAR CAST(xmlAsBlob AS CHAR CCSID 1208);
 

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSQTW3","label":"IBM On Demand Consulting for Hybrid Cloud"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

More support for:
IBM On Demand Consulting for Hybrid Cloud

Software version:
All Versions

Document number:
771833

Modified date:
22 March 2019

UID

ibm10771833

Manage My Notification Subscriptions