skip to main content
Querying data stores with SQL : Supported scalar functions : Scalar Function Support for DB2
  

Try Now

Scalar Function Support for DB2

The table identifies the scalar functions that Hybrid Data Pipeline supports for DB2.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 175. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
COALESCE
BLOB
ABSVAL
CURTIME
DEREF
CHAR
ACOS
DATE
DLCOMMENT
CHR
ASIN
DAY
DLLINKTYPE
CLOB
ATAN
DAYNAME
DLURLCOMPLETE
CONCAT
ATANH
DAYOFWEEK
DLURLPATH
DBCLOB
ATAN2
DAYOFYEAR
DLURLPATHONLY
DIFFERENCE
BIGINT
DAYS
DLURLSCHEME
GRAPHIC
CEIL
HOUR
DLURLSERVER
HEX
CEILING
JULIAN_DAY
DLVALUE
INSERT
COS
MICROSECOND
EVENT_MON_STATE
LCASE
COSH
MIDNIGHT_SECONDS
GENERATE_UNIQUE
LEFT
COT
MINUTE
NODENUMBER
LENGTH
DECIMAL
MONTH
NULLIF
LOCATE
DEGREES
MONTHNAME
PARTITION
LONG_VARCHAR
DIGITS
NOW
RAISE_ERROR
LONG_VARGRAPHIC
DOUBLE
QUARTER
TABLE_NAME
LOWER
EXP
SECOND
TABLE_SCHEMA
LTRIM
FLOAT
TIME
TRANSLATE
POSSTR
FLOOR
TIMESTAMP
TYPE_ID
REPEAT
INTEGER
TIMESTAMP_ISO
TYPE_NAME
REPLACE
LN
TIMESTAMPDIFF
TYPE_SHEMA
RIGHT
LOG
WEEK
VALUE
RTRIM
LOG10
YEAR
SOUNDEX
MOD
SPACE
POWER
SUBSTR
RADIANS
TRUNC
RAND
TRUNCATE
REAL
UCASE
ROUND
UPPER
SIGN
VARCHAR
SIN
VARGRAPHIC
SINH
SMALLINT
SQRT
TAN
TANH
TRUNCATE