The data types for the table attributes reported by a summary HELP STATISTICS request are as follows:
| Attribute | Description | Data Type |
|---|---|---|
| Date | The date on which statistics were last collected. | CHARACTER(8) CHARACTER SET UNICODE |
| Time | The time at which statistics were last collected. | CHARACTER(8) CHARACTER SET UNICODE |
| Unique Values | An estimate of the number of unique values for the specified column set. | VARCHAR(20) CHARACTER SET UNICODE |
| Column Names | The names of the columns for which summary statistics are reported. | VARCHAR(2000) The requirement of a 2,000 character maximum derives from the maximum number of columns per index and the maximum length of a column name plus overhead: (64 * 30) + 63 = 1983 characters. On a standard language support system, the data type for Column Names is VARCHAR(2000) CHARACTER SET LATIN. On a Japanese language support system, the data type for Column Names is VARCHAR(2000) CHARACTER SET UNICODE if a multibyte site-defined session character set such as UTF-8, UTF-16, Chinese, or Korean is used. For any other language support system, the data type for Column Names is VARCHAR(2000) CHARACTER SET UNICODE. The server character set for Column Names is Unicode, which gets translated to the client character set. If there is multibyte character data, Column Names uses the UTF-8, UTF-16, or some other character sets that supports multibyte client character sets. |