Create a stored procedure that can receive XML doc as parameter

435 pts.
Tags:
AS/400
RPG
XML
Tammy needs to create a stored procedure on the iSeries that can receive an XML document as a parameter. Also, the stored procedure will then need to call an RPGLE program with the XML doc as a parameter to it. The first thing she'd like to know is if that is even possible. If so, does anyone have an example? -- Michelle Davidson, editor, Search400.com

Answer Wiki

Thanks. We'll let you know when a new response is added.

In this case, it seems to me that the xml document is just a string. An a string can be passed to the stored proc. (be carefull to the max-size message accepted by the server, particularly if it is a web application)

After the stored proc has passed the string to rpg, then look at

http://www.scottklement.com/expat/

and

http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewNewsletterArticle&webID=1001&newsID=5012&issueID=5164&articleID=50719

scott has developped some samples of using expat to parse xml with rpg

Discuss This Question:  

 
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

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