Queries regarding Interbase

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.

Please do not multipost or cross post your messages. It violates
Borland's guidelines for using their newsgroups and wastes everyone's
time. Please post one message in the most appropriate newsgroup and
please take a moment to read the newsgroup guidelines at
http://info.borland.com/newsgroups/guide.html

--