Create a stored procedure that can receive XML doc as parameter
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
Software/Hardware used:
Software/Hardware used:
ASKED:
September 13, 2005 1:52 PM
UPDATED:
September 13, 2005 4:12 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
