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 ControlPublicAccessContainmentUnspecified
StaticNoDerivedNo


Property Settings

Data Modeler
dmItemFalseDMName 
Ordinal0IsIdentityFalse
IsUniqueFalseNullsAllowedFalse
Length0Scale0
ColumnTypeNativeForBitDataFalse
DefaultValueType DefaultValue 
SourceId SourceType 
OIDFalse