The ESQL/C function library

The HCL OneDB™ ESQL/C function library provides functions for data conversion of data types.

The HCL OneDB ESQL/C function library does provide additional functions. However, any function not listed in the following table is not valid within a DataBlade® API module.

Table 1. HCL OneDB ESQL/C functions for data conversion of data types
Function category ESQL/C library function
Byte

bycmpr()
bycopy()

byfill()
byleng()
Character processing

ldchar()
rdownshift()
rstod()
rstoi()
rstol()
rupshift()

stcat()
stchar()
stcmpr()
stcopy()
stleng()
DECIMAL type

MONEY type

decadd()
deccmp()
deccopy()
deccvasc()
deccvdbl()
deccvint()
deccvlong()
decdiv()
dececvt()
decfcvt()

decmul()
decround()
decsub()
dectoasc()
dectodbl()
dectoint()
dectolong()
dectrunc()
rfmtdec()
DATE type

rdatestr()
rdayofweek()
rdefmtdate()
rfmtdate()
rjulmdy()

rleapyear()
rmdyjul()
rstrdate()
rtoday()
DATETIME type

dtaddinv()
dtcurrent()
dtcvasc()
dtcvfmtasc()
dtextend()

dtsub()
dtsubinv()
dttoasc()
dttofmtasc()
INTERVAL type

incvasc()
incvfmtasc()
intoasc()
intofmtasc()

invdivdbl()
invdivinv()
invextend()
invmuldbl()
INT8 type

ifx_int8add()
ifx_int8cmp()
ifx_int8copy()
ifx_int8cvasc()
ifx_int8cvdbl()
ifx_int8cvdec()
ifx_int8cvflt()
ifx_int8cvint()
ifx_int8cvlong()

ifx_int8div()
ifx_int8mul()
ifx_int8sub()
ifx_int8toasc()
ifx_int8todbl()
ifx_int8todec()
ifx_int8toflt()
ifx_int8toint()
ifx_int8tolong()
Other C-language data types rfmtdouble() rfmtlong()