XSRANNOTATIONINFO table
The XSRANNOTATIONINFO table contains one row for each annotation in an XML schema to record the table and column information for the annotation. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| XSROBJECTID |
INTEGER
|
Internal identifier of the XML schema | G |
| ANNID | INTEGER | Internal identifier of the XML schema annotation | G |
| TABSCHEMA | VARCHAR(128) | Schema of the table for which annotation information is recorded | G |
| TABNAME | VARCHAR(128) | Name of the table for which annotation information is recorded | G |
| ROWSET | INTEGER | Name of the rowset for this annotation | G |
| COLNAME | VARCHAR(30) | Name of the column for this annotation | G |
| COLTYPE | INTEGER | Data type of the column for this annotation | G |
| INSTANCETYPE | INTEGER | Type of data that is provided by the parser during decomposition:
|
G |
| TRUNCATE | INTEGER | Indication of whether data can be truncated:
|
G |
| EXPRESSION | VARCHAR(1024) | Expression to be applied to data on insert by Db2 | G |
| CONDITION | VARCHAR(1024) | Condition to be applied before any data is inserted by Db2 | G |
| CASTEXPRESSION | VARCHAR(20) | Cast expression to be applied when the column data is inserted by Db2 during decomposition. | G |
| RELCREATED | CHAR(1) NOT NULL | The release of Db2 that is used to create the object. See the information on release dependency indicators in Db2 catalog tables for the values. | G |
