Programming Languages on Power

Power Programming Languages

IBM Power, including the AIX, IBM i, and Linux operating systems, support a wide range of programming languages, catering to both traditional enterprise applications and modern development needs.


#Power

 View Only
Back to discussions
Expand all | Collapse all

DB2 SQL Function to Read BLOB and Traverse XML/JSON

  • 1.  DB2 SQL Function to Read BLOB and Traverse XML/JSON

    Posted Fri October 27, 2023 11:22 AM

    Hi All,

    We are looking for a way to query table column MAXINTERRORMSG.MSGDATA  (BLOB Data) and extract a particular tag value via SQL Query like below.

    I search online and could not find any DB2 Functions that can do above.

    I am looking for help on what DB2 Functions are available to read BLOB fields and extract a tag value be it a JSON or an XML.



    ------------------------------
    Vikram Alla
    ------------------------------

    #SQL


  • 2.  RE: DB2 SQL Function to Read BLOB and Traverse XML/JSON

    Posted Sat October 28, 2023 09:48 AM
      |   view attached

    Dear Vikram

    There was a big XML support enhancement in DB2 for i 7.1's SQL.  You can find details in the file I attach to this post which contains 6-7 articles on this. 



    ------------------------------
    Chance favors only the prepared mind.
    -- Louis Pasteur
    ------------------------------
    Satid S.
    ------------------------------

    Attachment(s)

    pdf
    XML-V7R1 XML Support.pdf   1.52 MB 1 version
    Original Message


Related Content