-16252 THE `db2-xdb:rowSet` NAME `rowset-name` SPECIFIED AT OR NEAR LINE `lineno` IN THE XML SCHEMA DOCUMENT `uri` IS ALREADY ASSOCIATED WITH ANOTHER TABLE

Explanation
 A rowset in an annotated XML schema must correspond
to exactly one table. The rowset declaration at or near line lineno declares
an association between rowset rowsetname and the
table specified in the enclosing db2-xdb:table annotation. The specified
rowset has already been associated to a different table in another
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 such that each
rowset name is uniquely associated with exactly one table across the
annotated XML schema documents of the XML schema.

SQLSTATE
 225DE

-16252 THE db2-xdb:rowSet NAME rowset-name SPECIFIED AT OR NEAR LINE lineno IN THE XML SCHEMA DOCUMENT uri IS ALREADY ASSOCIATED WITH ANOTHER TABLE

Explanation

User response

SQLSTATE

-16252 THE `db2-xdb:rowSet` NAME `rowset-name` SPECIFIED AT OR NEAR LINE `lineno` IN THE XML SCHEMA DOCUMENT `uri` IS ALREADY ASSOCIATED WITH ANOTHER TABLE