mallik4u
New User
Joined: 17 Sep 2008 Posts: 75 Location: bangalore
|
|
|
|
hi,
We have a requirement to use HTTPGETCLOB function to get the XML document from HTTP and then Parse the XML in to a Mainframe file.
We are using the SQL similar to the following. GET and Parsing are working fine. But we want to know how to capture the HTTP RESPONSE. Please suggest:
SELECT X.*
FROM XMLTABLE('$XMLINPUT/Messages')
PASSING XMLPARSE(DOCUMENT
(DB2XML.HTTPGETCLOB(:WS-URL,''))
AS XMLINPUT
COLUMNS
COLA CHAR(15) PATH 'MessageCol1',
COLB CHAR(15) PATH 'MessageCol2
) AS X
Thanks,
Mallik |
|