HI,

if I want to execute this query

ResultSet rs = stmt.executeQuery(
"SELECT status, decomposition, decomposition_version FROM SYSIBM.SYSXSROBJECTS WHERE XSROBJECTNAME = 'BOOKDETAIL'");


this error is appears, so plz help me

DB2 SQL Error: SQLCODE=-16266, SQLSTATE=225D2, SQLERRMC=bookdetail;-530;23503;ADMIN.BOOK_AUTHOR.SQL110618213941760, DRIVER=3.62.56

thanks

SQLCODE -16266 stands for message SQL16266N

The message says that it basically wraps another SQL error, in this case for SQLCODE -530. And -530 (SQL0530N) is about a foreign key violation. So it seems that you decompose the document into a table on which a foreign key referencing some other table is defined. And that reference cannot be satisfied for at least 1 of the values/rows extracted from the XML document.