MicroStrategy ONE

IBM Informix

The tables listed below describe the MicroStrategy function support for IBM Informix databases:

IBM Informix IDS 11.5 and Informix Ultimate Edition 11.7
IBM Informix Ultimate Edition 12.1
IBM Informix XPS 8.x

IBM Informix IDS 11.5 and Informix Ultimate Edition 11.7

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count Max Min Multiply Stdev Sum Var
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	None
Rank and NTile functions	None
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim RightStr RTrim SubStr Trim
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Asin Atan Atan2 Ceiling Cos Exp Floor Int Int2 Ln Log10 Mod Power Quotient Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None

IBM Informix Ultimate Edition 12.1

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count Max Min Multiply Stdev Sum Var
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	FirstInRange Lag LastInRange Lead OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum
Rank and NTile functions	None
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim RightStr RTrim SubStr Trim
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Asin Atan Atan2 Ceiling Cos Exp Floor Int Int2 Ln Log10 Mod Power Quotient Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None

IBM Informix XPS 8.x

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count Max Min Multiply Stdev Sum Var
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	None
Rank and NTile functions	None
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim RightStr RTrim SubStr Trim
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Asin Atan Atan2 Ceiling Cos Exp Floor Int Int2 Ln Log10 Mod Power Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None