-16255   A db2-xdb:rowSet VALUE rowset-name USED AT OR NEAR LINE lineno IN XML SCHEMA DOCUMENT uri CONFLICTS WITH A db2-xdb:table ANNOTATION WITH THE SAME NAME.

Explanation

The annotated XML schema contains a db2-xdb:table annotation which declares a table named rowsetname, but the annotated XML schema does not have any db2-xdb:rowSet annotation declaration to associate rowsetname to any table. If a rowset is not declared in any db2-xdb:table annotation, it is implicitly associated to a table with the same name qualified by the value of db2-xdb:defaultSQLSchema. The annotated XML schema cannot use a db2-xdb:rowSet annotation that relies on an implicit association between a rowset and a table with the same name of rowset-name, and at the same time declare a table named rowset-name using a db2-xdb:table annotation. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of table SYSIBM.XSROBJECTCOMPONENTS.

The XML schema is not enabled for decomposition.

User response

Correct the annotated XML schema by adding a db2-xdb:rowSet child element to the db2-xdb:table element with name rowset-name. This will explicitly associate the rowset to the table.

SQLSTATE

225DE