Contains a set of rows for each column in the database with data type NCHAR. Used by the optimizer, each row contains a sample of values in the column.

The following table provides details of the SYSNCHARSTAT table.

Table 1. SYSNCHARSTAT system table
Column name Column data type Column size
colid INTEGER 4
tblid INTEGER 4
property INTEGER 4
attribute INTEGER 4
value VARCHAR 2000