Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    15

    Unanswered: select from SYSIBM.SYSXSROBJECTS error appears

    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

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •