troubleshooting Question

Query XML in DB2

Avatar of darrgyas
darrgyas asked on
DB2SQL
2 Comments2 Solutions1659 ViewsLast Modified:
Hi all,

Is there a way to to select just particular element(s) from a VARCHAR column that contains XML?

Example:
This is in the XML column -
<msg index="2">priority</msg>

Is there a way to select just index property (returns "2"), or just value
of the <msg> tag (returns priority)?

Any help is appreciated,

Thank you
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros