IBM® Data Server Provider for .NET supports the canonical functions.
The following table lists the canonical functions that the IBM entity provider supports. Canonical functions are translated to the corresponding data source functions by the data provider.
Canonical function type | LINQ function | DB2 for Linux, UNIX, and Windows | DB2 for z/OS | DB2 for i | Informix |
---|---|---|---|---|---|
Aggregate | Average | Yes | Yes | Yes | Yes |
BigCount | Yes | Yes | Yes | Yes | |
Count | Yes | Yes | Yes | Yes | |
Maximum | Yes | Yes | Yes | Yes | |
Minimum | Yes | Yes | Yes | Yes | |
NewGuid | Yes* | Yes* | Yes* | Yes* | |
StDev | Yes | Yes | Yes | Yes | |
StDevP | Yes | Yes | Yes | Yes | |
Sum | Yes | Yes | Yes | Yes | |
Var | Yes | Yes | Yes | Yes | |
VarP | Yes | Yes | Yes | Yes | |
Bitwise | BitWiseAnd | Yes | Yes* | Yes* | Yes |
BitWiseNot | Yes | Yes* | Yes* | Yes | |
BitWiseOr | Yes | Yes* | Yes* | Yes | |
BitWiseXor | Yes | Yes* | Yes* | Yes | |
Math | Abs | Yes | Yes | Yes | Yes |
Ceiling | Yes | Yes | Yes | Yes | |
Floor | Yes | Yes | Yes | Yes | |
Power | Yes | Yes | Yes | Yes | |
Round (value,digits) | Yes | Yes | Yes | Yes | |
Truncate (value,digits) | Yes | Yes | Yes | Yes | |
String | Concat | Yes | Yes | Yes | Yes |
Contains | Yes | Yes | Yes | Yes* | |
EndsWith | Yes | Yes | Yes | Yes | |
IndexOf | Yes | Yes | Yes | Yes* | |
Left | Yes | Yes | Yes | Yes | |
Length | Yes | Yes | Yes | Yes | |
LTrim | Yes | Yes | Yes | Yes | |
Replace | Yes | Yes | Yes | Yes | |
Right | Yes | Yes | Yes | Yes | |
RTrim | Yes | Yes | Yes | Yes | |
StartsWith | Yes | Yes | Yes | Yes | |
Substring | Yes | Yes | Yes | Yes | |
ToLower | Yes | Yes | Yes | Yes | |
ToUpper | Yes | Yes | Yes | Yes | |
Trim | Yes | Yes | Yes | Yes | |
Datetime | AddNanoseconds | Yes | Yes | Yes | Yes |
AddMicroseconds | Yes | Yes | Yes | Yes | |
AddMilliseconds | Yes | Yes | Yes | Yes | |
AddSeconds | Yes | Yes | Yes | Yes | |
AddMinutes | Yes | Yes | Yes | Yes | |
AddHours | Yes | Yes | Yes | Yes | |
AddDays | Yes | Yes | Yes | Yes | |
AddMonths | Yes | Yes | Yes | Yes | |
AddYears | Yes | Yes | Yes | Yes | |
CreateDateTime | Yes | Yes | Yes | Yes | |
CreateDateTimeOffset | Yes | ||||
CurrentDateTimeOffset | Yes | ||||
CreateTime | Yes | Yes | Yes | Yes | |
CurrentDateTime | Yes | Yes | Yes | Yes | |
CurrentUtcDateTime | Yes | Yes | Yes | ||
Day | Yes | Yes | Yes | Yes | |
DayOfYear | Yes | Yes | Yes | Yes | |
DiffNanoseconds | Yes | Yes | Yes | Yes* | |
DiffMicroseconds | Yes | Yes | Yes | Yes* | |
DiffMilliseconds | Yes | Yes | Yes | Yes* | |
DiffSeconds | Yes | Yes | Yes | Yes* | |
DiffMinutes | Yes | Yes | Yes | Yes* | |
DiffHours | Yes | Yes | Yes | Yes* | |
DiffDays | Yes | Yes | Yes | Yes* | |
DiffMonths | Yes | Yes | Yes | Yes* | |
DiffYears | Yes | Yes | Yes | Yes* | |
GetTotalOffsetMinutes | Yes | ||||
Hour | Yes | Yes | Yes | Yes | |
Millisecond | Yes | Yes | Yes | Yes | |
Minute | Yes | Yes | Yes | Yes | |
Month | Yes | Yes | Yes | Yes | |
Second | Yes | Yes | Yes | Yes | |
Truncate (datetime exp) | Yes | Yes | Yes | Yes | |
Year | Yes | Yes | Yes | Yes |