The XDB Server functions which are provided in addition to the standard SQL functions are normally available only when running in XDB mode. Check the following table or check the mode key below each function name. A diamond character (X) means the function is supported in that mode. The SQL compatibility mode can be set in your client configuration or with the SET COMPATIBILITY command.
| ANSI | DB2 | XDB | |
|---|---|---|---|
| AGE | X | ||
| ASCII | X | ||
| AVG | X | X | X |
| CEILING | X | ||
| CHAR | X | X | |
| CHR | X | ||
| COUNT | X | X | X |
| DATE | X | X | |
| DAY | X | X | |
| DAYOFYEAR | X | ||
| DAYS | X | X | |
| DECIMAL | X | X | |
| DIGITS | X | X | |
| FACTORIAL | X | ||
| FINDANY | X | ||
| FINDNOTIN | X | ||
| FINDSTR | X | ||
| FLOAT | X | X | |
| FLOOR | X | ||
| HEX | X | X | |
| HOUR | X | X | |
| INITCAP | X | ||
| INTEGER | X | X | |
| LENGTH | X | X | |
| LEVEL | X | ||
| LTRIM | X | ||
| MAX | X | X | X |
| MICROSECOND | X | X | |
| MIN | X | X | X |
| MINUTE | X | X | |
| MOD | X | ||
| MONTH | X | X | |
| MONTHBEG | X | ||
| MONTHSBTWN | X | ||
| NULLIF | X | X | X |
| PI | X | ||
| PREVIOUS | X | ||
| QUARTER | X | ||
| QUARTERBEG | X | ||
| REPLICATE | X | ||
| REVCHAR | X | ||
| ROUND | X | ||
| RTRIM | X | ||
| SECOND | X | X | |
| SIGN | X | ||
| STRIP | X | X | |
| SUBSTR | X | X | |
| SUM | X | X | X |
| TIME | X | X | |
| TIMESTAMP | X | X | |
| TODAY | X | ||
| TRUNCATE | X | ||
| VALUE | X | X | |
| WEEKDAY | X | ||
| WEEKOFYEAR | X | ||
| WEEKSBTWN | X | ||
| XABS | X | ||
| XCONCAT | X | ||
| XDATE | X | ||
| XEXP | X | ||
| XLEFT | X | ||
| XLN | X | ||
| XLOG | X | ||
| XLOWER | X | ||
| XPOWER | X | ||
| XRIGHT | X | ||
| XSQRT | X | ||
| XSTDDEV | X | ||
| XTRIM | X | ||
| XUPPER | X | ||
| XVAR | X | ||
| YEAR | X | X | |
| YEARBEG | X |