CODEWITHSUNDEEP
db2
Chris
Chris

Reputation: 53

Extract value from an xmlstring in db2

I have an XML string in a column called RawData from table Inbound. I have to read value Success from an element called status.

xmlstring:

<InboundMessage>
  <Transaction>
    <Status>Success</Status>
  </Transaction>
</InboundMessage>

Upvotes: 0

Views: 1062

Answers (1)

Mark Barinstein
Mark Barinstein

Reputation: 12314

SELECT X.STATUS
FROM (VALUES XMLPARSE(DOCUMENT '
<InboundMessage>
  <Transaction>
    <Status>Success</Status>
  </Transaction>
</InboundMessage>
')) T (DOC)
, XMLTABLE
(
'$D/InboundMessage/Transaction/Status' PASSING T.DOC AS "D" COLUMNS
  STATUS VARCHAR(20) PATH '.'
) X;

Refer to the XMLTABLE function overview link for more details.

Upvotes: 1

Related Questions