Function Name | Support | Comments |
|---|---|---|
_DATE | RESTRICT | Parameter must be a numeric literal. |
_DATE4 | RESTRICT | Parameter must be a numeric literal. |
_TIME | RESTRICT | Parameter must be a numeric literal. |
ABS | COMPAT | None |
ATAN | COMPAT | None |
AVG | COMPAT | None |
BIGINT | RESTRICT | None |
BIT_ADD | NO | None |
BIT_AND | NO | None |
BIT_NOT | NO | None |
BIT_OR | NO | None |
BIT_XOR | NO | None |
BYTE | NO | None |
C | NO | None |
CHAR | RESTRICT | If PARM2 is omitted, typecast_strlen is used instead, which is configured in CBF. For more information on typecast_strlen, see the Administrator Guide. |
CHAREXTRACT | RESTRICT | The first parameter may not be a literal NULL. The first parameter may be an expression that yields NULL. An error is returned if the second parameter is less than 1. |
CONCAT | COMPAT | None |
CORR | COMPAT | None |
COS | COMPAT | None |
COUNT | TRANS | None |
COVAR_POP | TRANS | None |
COVAR_SAMP | RESTRICT | The first parameter must be a literal. |
DATE | TRANS | None |
DATE_GMT | RESTRICT | Parameter must be a literal. Return value contains both date and time. |
DATE_PART | RESTRICT | Units must be a literal. The unit 'week' is not supported. Note that if the date is not in a host-acceptable format, it must be inside a DATE typecast. |
DATE_TRUNC | NO | None |
DBMSINFO | RESTRICT | Parameter must be a literal. May only be used as the inner most scalar(). Nesting dbmsinfo() is not supported. Valid request_name values are: _bintim _bio_cnt _cpu_ms _et_sec _version autocommit_state charset database dba query_language server_class terminal transaction_state username |
DECIMAL | COMPAT | None |
DOW | TRANS | None |
EXP | COMPAT | None |
FLOAT4 | TRANS | None |
FLOAT8 | TRANS | None |
GMT_TIMESTAMP | RESTRICT | Parameter must be a literal. |
HEX | COMPAT | None |
IFNULL | TRANS | None |
INT1 | NO | None |
INT2 | TRANS | None |
INT4 | RESTRICT | None |
INT8 | RESTRICT | None |
INTERVAL | NO | None |
INTEXTRACT | NO | None |
LEFT | RESTRICT | The first parameter may not be a literal NULL, but may be an expression that yields NULL. |
LENGTH | TRANS | None |
LN | COMPAT | None |
LOCATE | COMPAT | None |
LOG | COMPAT | None |
LONG_BYTE | TRANS | None |
LONG_VARCHAR | RESTRICT | Parameter one must be a string expression. Parameter one may not be a numeric data type or an expression that yields a numeric data type, and it may not be a host variable. |
LOWER | COMPAT | None |
LOWERCASE | TRANS | None |
MAX | COMPAT | None |
MIN | COMPAT | None |
MOD | COMPAT | None |
MONEY | RESTRICT | Translation is RESTRICT when money mapping is set to FLOAT. Translation is COMPAT when money mapping is set to DECIMAL(19,4). For more information, see the section Gateway Catalog Setup in the Administrator Guide. |
NOTRIM | NO | None |
OBJECT_KEY | NO | None |
PAD | NO | None |
POWER | RESTRICT | Result data type is the same as the first argument. Use a non-integer number in the first argument to avoid the result overflow for a large power. |
RANDOM | TRANS | None |
RANDOM(L,H) | RESTRICT | The first parameter must be a literal. |
RANDOMF | TRANS | None |
RANDOMF(L,H) | RESTRICT | The first parameter must be a literal. Return type is float8, whereas the Ingres return type varies depending on the type of the input parameters. |
REGR_AVGX | COMPAT | None |
REGR_AVGY | COMPAT | None |
REGR_COUNT | COMPAT | None |
REGR_INTERCEPT | COMPAT | None |
REGR_R2 | COMPAT | None |
REGR_SLOPE | COMPAT | None |
REGR_SXX | COMPAT | None |
REGR_SXY | COMPAT | None |
REGR_SYY | COMPAT | None |
RIGHT | RESTRICT | The first parameter may not be a literal NULL, but may be an expression that yields NULL. |
SHIFT | RESTRICT | The first parameter cannot be a host variable. The second parameter must be a literal. Results will not match Ingres when LENGTH(PARM1) + PARM2 exceed the original storage length of PARM1. |
SIN | COMPAT | None |
SIZE | NO | None |
SOUNDEX | COMPAT | None |
SQRT | COMPAT | None |
SQUEEZE | RESTRICT | The result string length is dependent on the SQUEEZE_LEN setting in CBF. The default value for SQUEEZE_LEN is 30. |
STDDEV_POP | TRANS | None |
STDDEV_SAMP | RESTRICT | The first parameter must be a literal. |
SUBSTRING | RESTRICT | The first parameter may not be a literal NULL, but may be an expression that yields NULL. |
SUM | COMPAT | None |
TABLE_KEY | NO | None |
TEXT | NO | None |
TRIM | TRANS | None |
UNHEX | NO | None |
UPPER | COMPAT | None |
UPPERCASE | TRANS | None |
VAR_POP | TRANS | None |
VAR_SAMP | TRANS | None |
VARBYTE | NO | None |
VARCHAR | RESTRICT | If PARM2 is omitted, typecast_strlen is used instead, which is configured in CBF. For more information on typecast_strlen, see the Administrator Guide. |