IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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

 


Similar Topics
Topic Forum Replies
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
No new posts Rexx log capturing CLIST & REXX 15
No new posts Parallelization in CICS to reduce res... CICS 4
No new posts MQ response when MQGET of a stopped q... Java & MQSeries 2
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
Search our Forums:

Back to Top