IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

HTTPGETCLOB Response capturing


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Sat Feb 14, 2015 1:02 am
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts ISPF search - capturing result TSO/ISPF 15
No new posts Invoke WebService failing with respon... CICS 3
No new posts Job is running with no response!!! DB2 3
No new posts Dynamic array request/response contai... CICS 2
This topic is locked: you cannot edit posts or make replies. CICS transaction slow response time All Other Mainframe Topics 5

Back to Top