create xml content from as/400 db2

5 pts.
Tags:
AS/400 DB2
DB/400
XML
Hi, wonder if these xml functions (XML2CLOB, XMLELEMENT, XMLATTRIBUTES, XMLAGG, ...) can be used in db/400 -- as/400 V6R1M0, if yes, any sample code? of not what else I can use to generate xml content from db2 queries? Any answer is appreciated.

Software/Hardware used:
db2 on as/400 iseries V6R1M0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    What all do you have installed on your system? Some possibilities are:
    • 5761DE1 IBM DB2 Extenders Version 9.1 for i5/OS
    • ...especially option 2 DB2 XML Extender
    • 5733XT1 XML Toolkit for iSeries
    • 5733XT2 XML Toolkit for IBM System i5
    Without knowing what you have available, it's hard to guess what might be possible for you. What languages or facilities would you be expecting to use? Tom
    125,585 pointsBadges:
    report
  • tantart
    have the same question too and currently im using as/400 V6R1M0 there is only 3 XML toolkits inside the V6R1M0 which is 5761DE1 2 5050 *CODE QDBXM V6R1M0 DB2 XML Extender 5761DE1 2 2905 *LNG QSYS2905 V6R1M0 DB2 XML Extender 5761DE1 2 2924 *LNG QDBXM V6R1M0 DB2 XML Extender I tried to use the function XML2CLOB but it returns token was not valid. Any idea is appreciated. Thanks
    40 pointsBadges:
    report
  • TomLiotta
    XML2CLOB is for DB2 UDB for Linux and Windows. It's not for DB2 on iSeries. You need to use the functions that are available in the product that you have. Try the XMLCLOBFromFile() function instead. You probably need to read the product documentation. Tom
    125,585 pointsBadges:
    report
  • tantart
    Thanks Tom. Will try that out.
    40 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following