Example: Specifying the behavior of concatenation with NULL
By default, when a string is concatenated with a NULL string, your database returns the original string. Actuate SQL, however, returns a NULL. You check your database documentation and find that there is an initialization statement that changes this behavior. You add the following code to your data source mapping:
<Initializers>
<Initializer>SET CONCAT_NULL_YIELDS_NULL ON</Initializer>
</Initializers>