The following table describes the function results data. If the function creates an output table, the bold columns comprise its Unique Primary Index (UPI).
Column | Data Type | Description |
---|---|---|
xidx | BYTEINT | Generated table identification number. Values 1 and 2 are reserved for number of records and number of unique records in table. |
xdb | VARCHAR(128) | Database where xtbl resides. |
xtbl | CHAR (128) | Table with overlap key, specified by tablename. "#records" and "#uniques" are included as pseudo-table names so that COL consists of number of records and number of unique records in table. Attribute length is at least 8 and at most the length of all table names or table aliases. |
xcol | VARCHAR(8) | [Column appears once for each table specified by tablename.] Count of overlapping records between each pairwise combination of tables. |
xcnt | FLOAT | Number of rows in the xtbl. |
xunique | FLOAT | Number of unique occurrences of xcol values in the xtbl. |