Use this stored procedure to calculate summary statistics of up to 1000 input columns of
the type boolean, smallint, integer, bigint, real, float, double, decfloat, decimal, and numeric.
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.SUMMARY1000NUM(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.
- All of these numeric column types are handled as double, where Boolean values are mapped to 0
(false) and 1 (true).
- Data type: VARCHAR(256)
- incolumn
- Optional.
- The columns of the input table of type boolean, smallint, integer, bigint, decimal, float,
double, and numeric that are separated by a semicolon (;).
- If this parameter is not specified, all columns of the input table of these types 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.SUMMARY1000NUM('intable=GOSALES.ORDER_HEADER, outtable=ORDER_HEADER_SUM1000NUM');
select * from ORDER_HEADER_SUM1000NUM;