Use this stored procedure to calculate summary statistics of up to 1000 input columns of
the type timestamp. You get information about the missing value count, non-missing value count,
average, variance, standard deviation, skewness, kurtosis, minimum, and maximum of the input
columns. Null values are counted but are not part of the statistics computation.
Authorization
The privileges held by the authorization ID of the statement must include the IDAX_USER role.
Syntax
IDAX.SUMMARY1000TIMESTAMP(in parameter_string varchar(32672))
Parameter descriptions
- parameter_string
- Mandatory one-string parameter that contains pairs of
<parameter>=<value> entries that are separated by a comma.
- Data type: VARCHAR(32672)
- The following list shows the parameter values:
-
- intable
- Mandatory.
- The name of the input table.
- Data type: VARCHAR(256)
- outtable
- Mandatory.
- The name of the output table to which the summary statistics are written.
- The output contains the following columns:
- columnname
- columnid
- countt
- average
- variance
- stddev
- skewness
- kurtosis
- minimum
- maximum
- missing
- If the by parameter is specified, an extra grouped_on column is added. It
indicates for which group the statistics are collected.
- If no statistics can be collected, for example, if there are fewer than two values for average,
the output table contains a NULL value.
- Average, minimum, and maximum are displayed as a timestamp. The standard deviation is displayed
as an interval. The variance is expressed in squared seconds.
- The variance column, the stddev column, the skewness column, and the kurtosis column are
calculated based on the number of days since 1 January 0001.
- Data type: VARCHAR(256)
- incolumn
- Optional.
- The columns of the input table of type timestamp that are separated by a semicolon (;).
- If this parameter is not specified, all columns of the input table of type timestamp are
analyzed.
- Default: none
- Data type: VARCHAR(ANY)
- by
- Optional.
- The column of the input table column that splits the data into the groups for which summary
statistics are to be collected.
- Default: none
- Data type: VARCHAR(128)
- talk
- Optional.
- Is deprecated and has no action.
- Default: no
- Data type: VARCHAR(3)
Returned information
INTEGER the number of rows in the output table.
Example
call IDAX.SUMMARY1000TIMESTAMP('intable=GOSALES.ORDER_HEADER, outtable=ORDER_HEADER_SUM1000TIMESTAMP');
select * from ORDER_HEADER_SUM1000TIMESTAMP;