🚀 go-pugleaf

We have come across some technical issues with interbase, which 
I think are important from the point of view of our application.
I am listing them as follows :

1) Rounding : Our application depends on the database to round the decimal number upto two decimal digits according to Java round function. It is explained in example which follows below.

   eg: 
   1> 123.039 should be rounded to 123.04.
   2> 123.034 should be rounded to 123.03.

   The ceil() or floor() functions cannot be used for both the
   operations. We want to know if there are any other UDF functions which would comply with the above requirements.

2) Start ibserver : The ibserver does not start after the system boots up in Suse 10.2. 
     It gives type following error :
     error while loading shared libraries : libdl.so.2 : cannot open shared object file : No such file or directory.
     What is the problem and how it can be fixed ?

3) Cross Platform Data Migration : The '*.gdb' database file created on Windows when transferred to linux (Suse 10.2) gives an exception with the message
   "-Implementation of text subtype 52 not located".
   On finding its details on the website it asked to install the 
   module named 'gdsintl'.
   We want to get the details regarding the downloading and installation of 'gdsintl' module.

4) Write and Load Data : Our application requires to write the data from a particular query temperorily into a file and load it back for further processing. It would be better if the operation is performed with the help of SQL query.  Are there any acilities in Interbase which enable us to carry out the above operations?

5) Performance : To increase the performance we have reviewed various parameters of the 'ibconfig' file and the PAGE_SIZE of the database. We also used compound indexing and foreign keys by normalizing the database. We would like to know if there are other techniques to increase the performance of the database.

6) Transactions : We require proper locking of the tables on which query operation is being performed. This helps to avoid concurrent modifications in multiuser system. Also in case of failed query operation we need to rollback to the previous position. It will be very kind of you if you send the details regarding the transaction support of interbase.

We would be pleased if you give us the possible options to meet our requirements.