11. OpenSQL Standard Catalogs : Standard Catalog Interface : The iistats Catalog
 
Share this page                  
The iistats Catalog
This catalog contains entries for columns that have statistics.
Column Name
Data Type
Description
table_name
char(256)
The name of the table.
table_owner
char(32)
The table owner's user name.
column_name
char(256)
The column name to which the statistics apply.
create_date
char(25)
The date on which statistics were gathered.
num_unique
float4
The number of unique values in the column.
rept_factor
float4
The repetition factor.
has_unique
char(1)
Contains Y if the column has unique values; otherwise, N.
pct_nulls
float4
The percentage (fraction of 1.0) of the table which contains NULL for the column.
num_cells
smallint
The number of cells in the histogram.
column_domain
smallint
Identifies the domain from which the column draws its values.
is_complete
char(1)
Contains Y if the column contains all possible values in its domain, N if the column does not contain all possible values in its domain, or blank if unknown.
stat_version
char(8)
Version of statistics (for example, ING6.5).
hist_data_length
smallint
Length of the histogram boundary values.