XSRANNOTATIONINFO
The XSRANNOTATIONINFO table contains one row for each annotation in an XML schema to record the table and column information about the annotation.
The following table describes the columns in the XSRANNOTATIONINFO table:
Column name | System Column Name | Data Type | Description |
---|---|---|---|
XSROBJECTID | OBJECTID | BIGINT | Internal identifier of the XML schema. |
ANNOTATION_ID | ANNOID | INTEGER | Internal identifier of the XML schema annotation. |
TABLE_SCHEMA | TABSCHEMA | VARCHAR(128) | Schema of the table to insert the data into. |
TABLE_NAME | TABNAME | VARCHAR(128) | Table to insert the data into. |
ROWSET | ROWSET | VARCHAR(1000) | Name of the rowset for this annotation. |
COLUMN_NAME | COLNAME | VARCHAR(128) | Name of the column for this annotation. |
DATA_TYPE | COLTYPE | INTEGER | Data type of the column for this annotation. |
INSTANCE_TYPE | INSTTYPE | INTEGER | Type of data that will
be provided by parser during decomposition:
|
TRUNCATE | TRUNCATE | INTEGER | Indication of whether
data can be truncated:
|
EXPRESSION | EXPRESSION | VARCHAR(1024) Nullable
|
Expression to be applied to data on insert by DB2®. |
CONDITION | CONDITION | VARCHAR(1024) Nullable
|
Condition to be applied before data is inserted by DB2. |
CAST_EXPRESSION | CASTEXP | VARCHAR(20) Nullable
|
Cast expression to be applied when the column data is inserted by DB2 during decomposition. |
IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number. |
ROWSET_ORDER | ORDER | INTEGER | RowSet order sequence. Default is 1. |