The following are the functions that the TIBCO Data Virtualization connector supports.
Supported functions are the functions that you can use when you work with in-database data tables, for example for calculated columns and custom expressions.
Important: Some supported functions might not be possible to use with your database. This depends on what functions are available in the database, which often differs between database versions and types
Date and Time Functions
Year, Quarter, Month, Day, DayName, DayOfMonth, Hour, Minute, Second, MilliSecond, Days_Between, Months_Between
Conversion Functions
SN
Math Functions
These functions are available if (Default) is selected in the System selection drop-down list in the TIBCO Data Virtualization Connection dialog.
Abs, ACos, ASin, ATan, Ceiling, Cos, Cot, Degrees, Exp, Floor, Log, Pi, Power, Radians, Round, Sin, Sqrt, Tan
Operators
+, -, *, /, %
Text Functions
These functions are available if (Default) is selected in the System selection drop-down list in the TIBCO Data Virtualization Connection dialog.
Concat, Instr, Length, Lower, LPad, RPad, RTrim, Trim, Upper, Space, Replace, Substring
Statistical Functions
These functions are available if (Default) is selected in the System selection drop-down list in the TIBCO Data Virtualization Connection dialog.
Sum, Avg, Max, Min, Count, UniqueCount
Specific Data Source Statistical Functions
These additional statistical functions are available if a specific database system is selected in the System selection drop-down list in the TIBCO Data Virtualization Connection dialog.
DB2
Stddev_Pop, Stddev_Samp, Variance_Pop, Variance_Samp
Greenplum
StdDev, StdDev_Pop, StdDev_Samp, Variance, Var_Pop, Var_Samp, Corr, CoVar_Pop, CoVar_Samp
Microsoft SQL Server
Stddev, Stddev_Pop, Stddev_Samp, Variance, Variance_Pop, Variance_Samp
MySQL
Stddev_Pop, Stddev_Samp, Var_Samp, Var_Pop
Netezza
Stddev, Stddev_Pop, Stddev_Samp, Variance, Var_Pop, Var_Samp
Oracle
Median, Variance, Var_Pop, Var_Samp, StdDev, StdDev_Pop, StdDev_Samp, Corr, CoVar_Pop, CoVar_Samp
Teradata
StdDev_Samp, StdDev_Pop, Var_Samp, Var_Pop
Vertica
Variance, Var_Pop, Var_Samp, StdDev, StdDev_Pop, StdDev_Samp, Corr, CoVar_Pop, CoVar_Samp, Median
PostgreSQL
StdDev, StdDev_Pop, StdDev_Samp, Variance, Var_Pop, Var_Samp, Corr, CoVar_Pop, CoVar_Samp
Hive
Variance, Var_Pop, Var_Samp, StdDev_Pop, StdDev_Samp, Corr, CoVar_Pop, CoVar_Samp
Specific Data Source Math Functions
These additional math functions are available if a specific database system is selected in the System selection drop-down list in the TIBCO Data Virtualization Connection dialog.
MySQL
Random
Netezza
Ln
Oracle
Ln
Vertica
Cbrt
Hive
Rand
Specific Data Source Text Functions
These additional text functions are available if a specific database system is selected in the System selection drop-down list in the TIBCO Data Virtualization Connection dialog.
Netezza
InitCap, Le_Dst, Dle_Dst
Oracle
Initcap
PostgreSQL
Initcap