The following table describes the function results data. If the function creates an output table, the bold columns comprise its Unique Primary Index (UPI).
To view the results properly when selecting from the result table, include the clause ORDER BY 1,2,3,5,4.
| Column | Data Type | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| xtbl | VARCHAR (128) | Table against which bin values are computed, specified by table. | ||||||||||
| xcol | VARCHAR (128) | [Column appears once for each column specified by columns.] Name or alias of column against which bin values are computed. | ||||||||||
| xbeg | FLOAT | Beginning boundary for bin of column. | ||||||||||
| xend | FLOAT | Ending boundary for bin of column. For important information about bin boundaries, see bins in Syntax. |
||||||||||
| xtype | BYTEINT | Calculated bin category:
|
||||||||||
| xdesc | CHAR (5) | Bin category description:
|
||||||||||
| xcnt | FLOAT | Number of rows in bin. | ||||||||||
| Xpct | FLOAT | Percentage of rows in bin. |