Hi,

In order to implement support for escaped syntax in JCA/JDBC driver, I
need to map JDBC functions to Firebird ones (if in UDF, UDF name
please). Can somebody help me with this mapping (if no mapping exist,
leave it empty):

Numeric functions:
-------------------------
ABS(number) -
ACOS(float) -
ASIN(float) -
ATAN(float) -
ATAN2(float1, float2) -
CEILING(number) -
COS(float) -
COT(float) -
DEGREES(number) -
EXP(float) -
FLOOR(number) -
LOG(float) -
LOG10(float) -
MOD(integer1, integer2) -
PI() -
POWER(number, power) -
RADIANS(number) -
RAND(integer) -
ROUND(number, places) -
SIGN(number) -
SIN(float) -
SQRT(float) -
TAN(float) -
TRUNCATE(number, places) -

String functions
----------------------------
ASCII(string) -
CHAR(code) -
CONCAT(string1, string2) - string1 || string2
DIFFERENCE(string1, string2) -
INSERT(string1, start, length, string2) -
LCASE(string) - LOWER(string)
LEFT(string, count) -
LENGTH(string) -
LOCATE(string1, string2[, start]) -
LTRIM(string) -
REPEAT(string, count) -
REPLACE(string1, string2, string3) -
RIGHT(string, count) -
RTRIM(string) -
SOUNDEX(string) -
SPACE(count) -
SUBSTRING(string, start, length) - SUBSTRING(string FROM start FOR length)
UCASE(string) - UPPER(string)

Date/Time functions:
-------------------------------
CURDATE() -
CURTIME() -
DAYNAME(date) -
DAYOFMONTH(date) -
DAYOFWEEK(date) -
DAYOFYEAR(date) -
HOUR(time) -
MINUTE(time) -
MONTH(date) -
MONTHNAME(date) -
NOW() -
QUARTER(date) -
SECOND(time) -
TIMESTAMPADD(interval, timestamp) -
TIMESTAMPDIFF(interval, timestamp1, timestamp2) -
WEEK(date) -
YEAR(date) -

System functions:
----------------------------------
DATABASE() -
IFNULL(expression, value) - COALESCE(expression, value)

Thanks in advance,
Roman Rokytskyy