Disabling the default mapping for a function
Your database may not support certain SQL-92 functions that are used by default to implement Actuate SQL functions. You must disable the default mappings for functions that are not supported. If you disable the mapping for a function, the Integration service performs the function instead of the database.
For example, some databases do not have an implementation of the POSITION function. The ODBC driver returns an error when the Integration service issues a query containing the POSITION function to such a database. To prevent the Integration service from encountering such errors, you should disable the mapping for the POSITION function in the mappings.xml file.

Additional Links:

Copyright Actuate Corporation 2012