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 Cisco Information Server 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 Cisco Information Server 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 Cisco Information Server 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 Cisco Information Server 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 Cisco Information Server 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 Cisco Information Server Connection dialog.
Netezza
InitCap, Le_Dst, Dle_Dst
Oracle
Initcap
PostgreSQL
Initcap
See also:
Cisco Information Server Data Types