Supported canonical functions
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 | Db2 for z/OS | Db2 for IBM 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 |
Important: Some of the canonical functions depend
on the server. The SQL0440N* error indicates that your
server does not support the specified function.