The following function will return XML as a string:
CREATE FUNCTION "DBA"."UNBlacklist"() returns long varchar url 'http://www.un.org/sc/committees/1267/consolidatedlist.xml' type 'HTTP:GET' ;
To extract stuff from it, use select ... from OpenXML().
answered 28 Dec '09, 10:28
Just as a quick start:
You should be able to download any web document with SA's web client procedures/functions.
I haven't done that myself so I can't give exact advice but you may have a look at the topics "SQL Anywhere web services" and "Web service clients", e.g. the following topic.
Just my thoughts
answered 28 Dec '09, 08:58