Summary table for conversion to the index XML data type
For data to convert successfully to the target index XML data type, the source value must be lexically valid according to the schema data type and index XML data type and the value must be within Db2® limits for the schema data type and index XML data type.
The following table summarizes how
values are handled when being converted to an index XML data type.
The value is valid according to the index XML data type (all values are valid for the xs:string data type) | The value is within Db2 limits for the index XML data type | Indexing result |
---|---|---|
No | not applicable | REJECT INVALID VALUES: Error IGNORE INVALID VALUES (default): The value is ignored and not indexed. |
Yes | Yes | The value is indexed. |
Yes | No | Error: the value is outside of Db2 limits. |