Use this stored procedure to calculate summary statistics of up to 1000 input columns of
the type date. 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.SUMMARY1000DATE(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 table 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.
- Internally, dates are stored as integers that represent the number of days since 1 January 0001.
The average, the minimum, and the maximum is displayed as a date. The standard deviation is
displayed in days. The variance is expressed in squared days.
- Data type: VARCHAR(256)
- incolumn
- Optional.
- The columns of the input table of type date that are separated by a semicolon (;).
- If this parameter is not specified, all columns of the input table of type date 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
create view ORDER_HEADER_DATE as select ORDER_NUMBER, date(ORDER_DATE) as ORDER_DATE, date(ORDER_CLOSE_DATE) as ORDER_CLOSE_DATE from GOSALES.ORDER_HEADER;
call IDAX.SUMMARY1000DATE('intable=ORDER_HEADER_DATE, outtable=ORDER_HEADER_SUM1000DATE');
select * from ORDER_HEADER_SUM1000DATE;