SELECT DB2XML.NEWS.* FROM XMLTABLE('$result/rss/channel/item' PASSING XMLPARSE( DOCUMENT DB2XML.HTTPGETBLOB('http://feeds.bbci.co.uk/news/world/rss.xml?edition=uk','') ) as "result" COLUMNS title VARCHAR(128) PATH 'title' ) AS RESULT, DB2XML.NEWS WHERE RESULT.TITLE = DB2XML.NEWS.TITLE

TITLE                                                                                                                                                                                                                                                            DESCRIPTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      LINK                                                                                                                                                                                                                                                            PUBDATE             
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------
Anti-Mubarak protesters hit back                                                                                                                                                                                                                                 Opponents of Egypt's President Mubarak go on the offensive, pushing counter-demonstrators out of side streets in central Cairo.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  http://www.bbc.co.uk/go/rss/int/news/-/news/world-middle-east-12357891                                                                                                                                                                                          Thu, 03 Feb 2011    
Algeria emergency 'to be lifted'                                                                                                                                                                                                                                 Algeria's state of emergency will be lifted in the "very near future", President Abdelaziz Bouteflika is quoted as saying by local media.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        http://www.bbc.co.uk/go/rss/int/news/-/news/world-middle-east-12359750                                                                                                                                                                                          Thu, 03 Feb 2011    
Burma confirms leader candidates                                                                                                                                                                                                                                 Lawmakers in Burma's new parliament elect junta allies as vice-presidents, putting them in the running for the role of leader.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   http://www.bbc.co.uk/go/rss/int/news/-/news/world-asia-pacific-12352764                                                                                                                                                                                         Thu, 03 Feb 2011    
Britons on Cairo charter flight                                                                                                                                                                                                                                  Some 181 people leave Egypt on a Foreign Office-chartered flight from Cairo to London, with a second flight being arranged.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      http://www.bbc.co.uk/go/rss/int/news/-/news/uk-12354575                                                                                                                                                                                                         Thu, 03 Feb 2011    
Breaking traditions                                                                                                                                                                                                                                              South African students share rooms in a bid to overcome racism                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   http://www.bbc.co.uk/go/rss/int/news/-/news/world-africa-12345773                                                                                                                                                                                               Wed, 02 Feb 2011    

  5 record(s) selected.


