|
SYSIBM.SYSCOLSTATS www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains partition statistics for selected columns. For each column, a row exists for each partition in the table. Rows are inserted when RUNSTATS collects either indexed column statistics or non-indexed column statistics for a partitioned table space. No row is inserted if the table space is nonpartitioned.
| Nome da coluna | Tipo de dado | Descrição | Uso |
| HIGHKEY | CHAR(8) NOT NULL FOR BIT DATA | Highest value of the column within the partition. Blank if statistics have not been gathered. If the column has a non-character data type, the data might not be printable. This is an updatable column. | S |
| HIGH2KEY | CHAR(8) NOT NULL FOR BIT DATA | Second highest value of the column within the partition. Blank if statistics have not been gathered. If the column has a non-character data type, the data might not be printable. | S |
| LOWKEY | CHAR(8) NOT NULL FOR BIT DATA | Lowest value of the column within the partition. Blank if statistics have not been gathered. If the column has a non-character data type, the data might not be printable. This is an updatable column. | S |
| LOW2KEY | CHAR(8) NOT NULL FOR BIT DATA | Second lowest value of the column within the partition. Blank if statistics have not been gathered. If the column has a non-character data type, the data might not be printable. This is an updatable column. | S |
| INTEGER NOT NULL | Number of distinct column values in the partition. This is an updatable column. | S | |
| STATSTIME | TIMESTAMP NOT NULL | If RUNSTATS updated the statistics, the date and time when the last invocation of RUNSTATS updated the statistics. If the value is '0001-01-02.00.00.00.000000', RUNSTATS should be run to update the statistics before they are used. This is an updatable column. | 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. | G |
| COLCARDDATA | VARCHAR(1000) NOT NULL FOR BIT DATA | Internal use only | I |