RE: Attempting to learn Web Services (by example)

Thank you.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Nicholas T Lawrence
Sent: Monday, June 03, 2013 11:41 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Attempting to learn Web Services (by example)


DB2 for i has tools available in 7.1 that are designed to access web
services:
https://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/stg_ast_sys_wp_access_web_service_db2_i_udf

You could invoke the web service from Run SQL Scripts and examine the results.

For example:
SELECT * FROM
XMLTABLE('/current_observation'
PASSING XMLPARSE(DOCUMENT
SYSTOOLS.HTTPGETBLOB(
-- URL
'http://w1.weather.gov/xml/current_obs/KRST.xml',

-- Header
'<httpHeader> <header name="Accept" value = "application/xml"/> </httpHeader>'
)
)
COLUMNS
"station_id" CHAR(5),
"observation_time" VARCHAR(400),
"weather" VARCHAR(25),
"temp_f" DOUBLE,
"windchill_f" DOUBLE
) Weather;




It's not going to help you format the syntax of your request, but it is easier to go from a prototype to actual code, especially if you intend to use the results from the service in conjunction with your database.


Nick Lawrence
DB2 for IBM i

Success is not final, failure is not fatal: it is the courage to continue that counts.
- Winston Churchill