TIBCO Data Virtualization® Adapter Online Help > TDV DB2 Adapter > DB2 Function Support > DB2 Analytic Function Support
 
DB2 Analytic Function Support
TDV supports the analytic functions listed in the table below for DB2..
DB2 Analytic Function
Notes
AVG
AVG DISTINCT not supported for versions 8 and 9.
COUNT
COUNT DISTINCT not supported for versions 8 and 9.
CUME_DIST
Supported only for version 11.
DENSE_RANK
 
MAX
MAX DISTINCT not supported for versions 8 and 9.
MIN
MIN DISTINCT not supported for versions 8 and 9.
PERCENT_RANK
 
RANK
 
ROW_NUMBER
 
SUM
SUM DISTINCT not supported for versions 8 and 9.