for InterBase and FireBird

Functions enclosed in FreeAdhocUDF.dll/.so/.dylib :
Diverse functions		10 functions
	diverse functions	4 functions
	NVL-functions	6 functions
		since InterBase 2007 this function is substitutable with a native SQL statem.
		since FireBird 2.0 this function is substitutable with a native SQL statement
		since FireBird 2.1 this function is substitutable with a native SQL statement
		Output RETURN mechanism if nothing other is published: FREE_IT TestSQLs with NULL run only in FireBird 2.0

 

Diverse functions
from		substitutable with CASE
from		substitutable with IIF
from		substitutable with DECODE
F_IF		function from adhoc
Entrypoint	aif	compatible with UTF-8
Input	CSTRING(32) CSTRING(8) CSTRING(32) CSTRING(8190) CSTRING(8190)	Comparisonstring 1 Comparisonoperator Comparisonstring 2 if comparison applies, then result = Parameter 4 if comparison does not apply, then result = Parameter 5
Output	CSTRING(8190)	s.o.
"reproduction" of a IF-loop Comparisonoperator         =         <>         <         >         <=         >=         Everyone of these operators a "n" (numeric) can be placed in front, if the two comparede strings contain floatingpoint, e.g. n = TestSQL SELECT 'Parameter 1 ist kleiner' AS ISCORRECT, F_IF('Test', '<=', 'Testa', 'Parameter 1 ist kleiner', 'Parameter 1 ist größer') FROM RDB$DATABASE; SELECT 'Parameter 1 ist größer' AS ISCORRECT, F_IF('Testb', '<=', 'Testa', 'Parameter 1 ist kleiner', 'Parameter 1 ist größer') FROM RDB$DATABASE; SELECT 'Parameter 1 ist kleiner' AS ISCORRECT, F_IF('Test1', 'n<=', 'Test2', 'Parameter 1 ist kleiner', 'Parameter 1 ist größer') FROM RDB$DATABASE; SELECT 'Parameter 1 ist kleiner' AS ISCORRECT, F_IF('123.45', 'n<=', '234.56', 'Parameter 1 ist kleiner', 'Parameter 1 ist größer') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_IF(NULL, NULL, NULL, NULL, NULL) FROM RDB$DATABASE;
F_VERSION		function from adhoc
Entrypoint	version	compatible with UTF-8
Input	without
Output	CSTRING(30)	version of FreeAdhocUDF
TestSQL SELECT F_VERSION() FROM RDB$DATABASE;
F_VERSIONNAME		function from adhoc
Entrypoint	versionname	compatible with UTF-8
Input	without
Output	CSTRING(255)	name of the version of FreeAdhocUDF
TestSQL SELECT F_VERSIONNAME() FROM RDB$DATABASE;
F_OSLANGUAGE		function from adhoc
Entrypoint	oslanguage	compatible with UTF-8
Input	without
Output	CSTRING(30)	language of the operationg system
TestSQL SELECT F_OSLANGUAGE() FROM RDB$DATABASE;

NVL functions
	These functions doesn't run in InterBase and FireBird 1.x
F_SNVL		function from adhoc
Entrypoint	snvl	compatible with UTF-8
Input	CSTRING(32760) CSTRING(32760)	value to check if NULL return instead of NULL
Output	CSTRING(32760)	value
version for strings
F_SNVL2		function from adhoc
Entrypoint	snvl2	compatible with UTF-8
Input	CSTRING(32760) CSTRING(32760) CSTRING(32760)	value to check if NULL return instead of NULL return instead of param 1
Output	CSTRING(32760)	value
version for strings with set value for not NULL
F_INVL		function from adhoc
Entrypoint	invl	compatible with UTF-8
Input	INTEGER INTEGER	value to check if NULL return instead of NULL
Output	INTEGER	value
version for integer
F_INVL2		function from adhoc
Entrypoint	invl2	compatible with UTF-8
Input	INTEGER INTEGER INTEGER	value to check if NULL return instead of NULL return instead of param 1
Output	INTEGER	value
version for integer with set value for not NULL
F_DNVL		function from adhoc
Entrypoint	dnvl2	compatible with UTF-8
Input	DOUBLE DOUBLE	value to check if NULL return instead of NULL
Output	DOUBLE	value
version for double precision
F_DNVL2		function from adhoc
Entrypoint	dnvl2	compatible with UTF-8
Input	DOUBLE DOUBLE DOUBLE	value to check if NULL return instead of NULL return instead of param 1
Output	DOUBLE	value
version for double precision with set value for not NULL All Functions like Oracle-NVL-functions. TestSQL SELECT 'is NULL' AS ISCORRECT, F_SNVL(NULL, 'is NULL') FROM RDB$DATABASE; SELECT 'this is not NULL' AS ISCORRECT, F_SNVL('this is not NULL', 'is NULL') FROM RDB$DATABASE; SELECT 'is NULL' AS ISCORRECT, F_SNVL2(NULL, 'not NULL', 'is NULL') FROM RDB$DATABASE; SELECT 'not NULL' AS ISCORRECT, F_SNVL2('this is not NULL', 'not NULL', 'is NULL') FROM RDB$DATABASE; SELECT 9999 AS ISCORRECT, F_INVL(NULL, 9999) FROM RDB$DATABASE; SELECT 3 AS ISCORRECT, F_INVL(3, 999) FROM RDB$DATABASE; SELECT 9999 AS ISCORRECT, F_INVL2(NULL, 999, 9999) FROM RDB$DATABASE; SELECT 123 AS ISCORRECT, F_INVL2(3, 123, 9999) FROM RDB$DATABASE; SELECT 0.0001 AS ISCORRECT, F_DNVL(NULL, 0.0001) FROM RDB$DATABASE; SELECT 3.0 AS ISCORRECT, F_DNVL(3.0, 0.0001) FROM RDB$DATABASE; SELECT 0.0001 AS ISCORRECT, F_DNVL2(NULL, 3.333, 0.0001) FROM RDB$DATABASE; SELECT 3.333 AS ISCORRECT, F_DNVL2(3.0, 3.333, 0.0001) FROM RDB$DATABASE;