Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

HTTPGETCLOB Response capturing

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: HTTPGETCLOB Response capturing
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am
No new posts How to calculate an specific transact... lind sh CICS 2 Tue Sep 13, 2016 9:20 pm
No new posts RMF Command for DASD response time tr... vasanthz All Other Mainframe Topics 2 Thu Nov 26, 2015 4:32 am
No new posts Capturing Cobol Program Displays luis_pr TSO/ISPF 1 Wed Jun 03, 2015 5:01 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us