The ESQL/C function library

The Informix® ESQL/C function library provides functions for data conversion of data types.

The Informix® 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. Informix® 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()