SYSNCHARSTAT

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

The following table provides details of the SYSNCHARSTAT table.

Table 9. 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