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:

Table 1. 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: 2 decimal 4 long integer 5 integer 6 short integer 16 string 30 datetime 41 float 42 double
TRUNCATE	TRUNCATE	INTEGER	Indication of whether data can be truncated: 0 Data cannot be truncated 1 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.