for InterBase and FireBird

Functions enclosed in FAUfile.dll/.so/.dylib :
File functions		3 functions
	with BLObs	2 functions
	diverse file functions	1 function
		Output RETURN mechanism if nothing other is published: FREE_IT TestSQLs with NULL run only in FireBird 2.0
Attention! Importend! For security reasons we had swaped out the file functions in an own library, because you can access to filesystem with the database-client without right-system. If you didn't wont this security-whole, dispence on the file functions and implicitly of the file FAUfile.dll/.so/.dylib in folder ../UDF.

        

File functions: with BLObs
F_BLOBLOAD		function from adhoc
Entrypoint	blob_load	compatible with UTF-8
Input	CSTRING(8191)	complete path with filename
Output	BLOB	load (binary)File in a BLOB
TestSQL Windows: (please adapt your path and IDs) SELECT F_BLOBLOAD('C:\boot.ini') FROM RDB$DATABASE; INSERT INTO BLOBTEST (TEXTBLOB, BINAERBLOB) SELECT 'PNG-picture' || F_CRLF() || 'FreeAdhocUDF.png', F_BLOBLOAD('C:\copy\FreeAdhocUDF.png') FROM RDB$DATABASE; UPDATE BLOBTEST SET TEXTBLOB = 'PNG-picture' || F_CRLF() || 'firebird-logo-400.png', BINAERBLOB = F_BLOBLOAD('c:\copy\firebird-logo-400.png') WHERE BLOBTESTID = 14 Linux:(please adapt your path and IDs) SELECT F_BLOBLOAD('/etc/passwd') FROM RDB$DATABASE; SELECT F_BLOBLOAD('/daten/copy/FreeAdhocUDF.png') FROM RDB$DATABASE; INSERT INTO BLOBTEST (TEXTBLOB, BINAERBLOB) SELECT 'PNG-picture' || F_CRLF() || 'FreeAdhocUDF.png', F_BLOBLOAD('/daten/copy/FreeAdhocUDF.png') FROM RDB$DATABASE; UPDATE BLOBTEST SET TEXTBLOB = 'PNG-picture' || F_CRLF() || 'firebird-logo-400.png', BINAERBLOB = F_BLOBLOAD('/daten/copy/firebird-logo-400.png') WHERE BLOBTESTID = 14
F_BLOBSAVE		function from adhoc
Entrypoint	blob_save	compatible with UTF-8
Input	CSTRING(8191) BLOB	complete path with filename BLOb to save
Output	INTEGER	size of saved file in bytes
Output file system		saves (binary)file from a BLOB into filesystem
TestSQL Windows: (please adapt your path and IDs) SELECT F_BLOBSAVE('c:\copy\textblob.txt', TEXTBLOB), F_BLOBSAVE('c:\copy\picture.png', BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 14 Linux:(please adapt your path and IDs) SELECT F_BLOBSAVE('/daten/copy/textblob.txt', TEXTBLOB), F_BLOBSAVE('/daten/copy/picture.png', BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 14

File functions: diverse file functions
F_FILEVERSION		function from adhoc
Entrypoint	fileversion	compatible with UTF-8
Input	without
Output	CSTRING(255)	version of FAUfile
TestSQL SELECT F_FILEVERSION() FROM RDB$DATABASE;