Use this stored procedure to calculate summary statistics of up to 1000 input columns of
type char, nchar, varchar, or nvarchar of any length. You get information about the number of
missing and non-missing values, the number of distinct values, and the frequency of the most
frequent value. 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.SUMMARY1000CHAR(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:
- colname
- distinctvalues
- mostfrequentvalue
- mostfrequentcases
- nonmissingcases
- 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, the output table contains a NULL value.
- Data type: VARCHAR(256)
- incolumn
- Optional.
- The columns of the input table of type char, nchar, varchar, or nvarchar of any length 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.SUMMARY1000CHAR('intable=GOSALES.ORDER_HEADER, outtable=ORDER_HEADER_SUM1000CHAR');
select * from ORDER_HEADER_SUM1000CHAR;