How do I set up supported functions for the Retain Server? [Ent]
Return to Introduction Previous Topic Next page

If you are using a SQL Server database, you may be able to improve the performance of the Retain Server by indicating that the database to which you are connecting supports certain functions.

SQL Server 7 and below did not support functions and so the following should not be added - if you have SQL Server 2000 or above then it is likely that Retain will have provided you with the appropriate functions, though you should check this before adding them to the ini file. You can check by selecting your database in SQL Server Enterprise Manager and selecting 'User Defined Functions'. If these functions are not supported and you have SQL Server 2000 or beyond, you should contact Retain.

Assuming these functions are supported, there should be a section in your Retain Server configuration file (svrcnfg.ini) as below:

[SupportedFns]
GreatestInteger = Supported
LeastInteger = Supported
GreatestVariant = Supported
LeastVariant = Supported
GreatestFloat = Supported
LeastFloat = Supported