Hello.

I have some problems with namespaces in DB2 9.7.1 LUW. To make it short I provide simple example:

I insert data

insert into T1 values
(1,1,'<CUSTOMER> <NAME> <FIRST_NAME>JOHN</FIRST_NAME> </NAME> </CUSTOMER>');
insert into T1 values
(1,1,'<CUSTOMER xmlns="http://first/namespace" xmlns:na="http://second/namespace"> <na:NAME> <na:FIRST_NAME>Sarah</na:FIRST_NAME> </na:NAME> </CUSTOMER>');

xquery for $d in db2-fn:xmlcolumn("T1.CUSTOMER")/CUSTOMER/*:NAME return $d/*:FIRST_NAME

I get only 1 record ->JOHN
Any ideas why the second one is not selected?

I have a few namespaces in each document, so I need some kind universal solution that is why I use wildcards.