create table items (
id int primary key not null,
brandname varchar(30),
itemname varchar(30),
sku int,
srp decimal(7,2),
comments xml
)


Suppose if a table has above structure and I want to delete records from table depending upon a value in xml document. How can I do that? Can't find any solution

SQL and XQuery tutorial for IBM DB2:
SQL and XQuery tutorial for IBM DB2: SQL and XQuery tutorial series for IBM DB2

Use XMLEXISTS() if your DB2 version supports it. There are plenty of examples in the manual.

Thanks alot for reply xmlexists worked