If an Actuate SQL query contains a function, the Integration service must convert the function into a database function that returns the same results. To convert an Actuate SQL function to a database function, the Integration service uses function templates in a mappings.xml file. A function template contains a database function that is substituted for the Actuate SQL function when the query is sent to the database. The mappings.xml file in the Base_Mappings directory contains the default function templates.
If your database is ODBC-compliant and the database function is exactly like an Actuate SQL function, then the Integration service can perform the mapping for you using ODBC escape sequences. Relational databases, however, frequently differ in their implementation of SQL functions. Thus, when you configure a new database type you must resolve discrepancies in function implementations.
If your database does not support a function used in an Actuate SQL query, then you cannot map the function. The function must be performed by the Integration service.
