int
cardinality, in Class DB2Function
Documentation
From the UDB 7.1 documentation for CREATE FUNCTION (External Table):
This optional clause provides an estimate of the expected number of rows
to be returned by the function for optimization purposes. Valid values for
integer range from 0 to 2,147,483,647 inclusive.
If the CARDINALITY clause is not specified for a table function, DB2 will
assume a finite value as a default- the same value assumed for tables for
which the RUNSTATS utility has not gathered statistics.
Warning: if a function does in fact have infinite cardinality, i.e. it returns a
row every time it is called to do so, never returning the .end-of-table.
condition, then queries which require the .end-of-table. condition to
correctly function will be infinite, and will have to be interrupted.
Examples of such queries are those involving GROUP BY and ORDER BY.
The user is advised to not write such UDFs.
Export Control | PublicAccess | Containment | Unspecified |
Static | No | Derived | No |
Property Settings
Data Modeler
dmItem | False | DMName | |
Ordinal | 0 | IsIdentity | False |
IsUnique | False | NullsAllowed | False |
Length | 0 | Scale | 0 |
ColumnType | Native | ForBitData | False |
DefaultValueType | | DefaultValue | |
SourceId | | SourceType | |
OID | False | | |