|
SYSIBM.SYSCOLDISTSTATS www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains zero or more rows per partition for the first key column of a partitioned index. Rows are inserted when RUNSTATS scans index partitions of the partitioned index. No row is inserted if the index is a nonpartitioned index. Rows in this table can be inserted, updated, and deleted.
| Nome da coluna | Tipo de dado | Descrição | Uso |
| SMALLINT NOT NULL | Not used | N | |
| STATSTIME | TIMESTAMP NOT NULL WITH DEFAULT | If RUNSTATS updated the statistics, the date and time when the last invocation of RUNSTATS updated the statistics. | G |
| IBMREQD | CHAR(1) NOT NULL | Whether the row came from the basic machine-readable material (MRM) tape. N No Y Yes |
G |
| PARTITION | SMALLINT NOT NULL | Partition number for the table space containing the table in which the column is defined. | G |
| TBOWNER | CHAR(8) NOT NULL | Authorization ID of the owner of the table that contains the column. | G |
| TBNAME | VARCHAR(18) NOT NULL | Name of the table that contains the column. | G |
| NAME | VARCHAR(18) NOT NULL | Name of the column. If NUMCOLUMNS is greater than 1, this name identifies the first column name of the set of columns associated with the statistics. | G |
| COLVALUE | VARCHAR(254) NOT NULL FOR BIT DATA | Contains the data of a frequently occurring value. If the value has a non-character data type, the data may not be printable. |
S |
| TYPE | CHAR(1) NOT NULL WITH DEFAULT 'F' |
The type of statistics gathered: C Cardinality F Frequent Value |
G |
| CARDF | FLOAT NOT NULL WITH DEFAULT -1 |
The number of distinct values for the column group. This number is valid only for TYPE C statistics. | S |
| COLGROUPCOLNO | VARCHAR(254) NOT NULL WITH DEFAULT |
Identifies the set of columns associated with the statistics. If the statistics are only associated with a single column, the field contains a zero length. Otherwise, the field is an array of SMALLINT column numbers with a dimension equal to the value in NUMCOLUMNS. This is an updatable column. | S |
| NUMCOLUMNS | SMALLINT NOT NULL WITH DEFAULT 1 |
Identifies the number of columns associated with the statistics. | G |
| FREQUENCYF | FLOAT NOT NULL WITH DEFAULT -1 |
Gives the percentage of rows in the table with the value specified in COLVALUE when the number is multiplied by 100. For example, a value of 1 indicates 100%. A value of .153 indicates 15.3%. | G |