TIBCO Data Virtualization® Adapter Online Help > TDV DB2 Adapter > DB2 Function Support > DB2 Analytic Aggregate Function Support
 
DB2 Analytic Aggregate Function Support
TDV supports the analytic aggregate functions listed in the table below for DB2.
DB2 Analytic Aggregate Function
Notes
MEDIAN
Supported only for version 11.
PERCENTILE_CONT
Supported only for version 11.
PERCENTILE_DISC
Supported only for version 11.
STDDEV
Supported only for version 11.
Note: To prevent nonstandard results, add OPTION STRICT to the query.
STDDEV_POP
 
STDDEV_SAMP
Not supported for version 8.
VARIANCE_POP
 
VARIANCE_SAMP
Not supported for version 8.