Supported Functions


Date and Time functions

Day, DayName, DayOfWeek, DayOfYear, Hour, Microsecond, Minute, Month, MonthName, Month_Between, Next_Day, Quarter, Second, Week, WeekOfYear, Year, DayOfMonth, SecondOfDay, WeekOfMonth

Conversion functions

SN

Math functions

Abs, Ceiling, Degress, Exp, Floor, Ln, Log10, Max, Min, Mod, Power, Radians, Rand, Round, Sign, Sqrt, Trunc, Acos, Asin, Atan, Atan2, Atanh, Cos, Cosh, Cot, Sin, Sinh, Tan, Tanh

Operators

 %, -, +, *, /

Statistical functions

Avg, Count, UniqueCount, Count_Big, Min, Max, Stddev, Sum, Variance

Text functions

ASCII, Concat, Initcap, Insert, Instr, Lcase, LeftStr, Length, Lower, Lpad, Ltrim, Overlay, Position, PosStr, Repeat, Replace, RightStr, Rpad, Rtrim, Soundex, Space, SubStr, Trim, Ucase, Upper

 

Binning is not supported by this connector.

See also:

Details on IBM DB2 Connection

IBM DB2 Data Types