Product specifications

$(+): this syntax is used with Oracle.
$*: this syntax is used with Sybase, MS SQL Server and IBM Red Brick.
Note:
$ represents a join expression.
Values
See values above.Default
If table1.col1 is joined to table2.col2 in Oracle, the expression
generated is then : table1.col1(+) = table2.col2.
Example
13.1.19 LIKE_SUPPORTS_ESCAPE_CLAUSE
<Parameter Name="LIKE_SUPPORTS_ESCAPE_CLAUSE">YES</Parameter>
Specifies if the database supports the use of an ESCAPE clause within
the LIKE condition of the SQL statement.
Description
YES: the database supports the ESCAPE clause in the LIKE condition.
NO: the database does not support the ESCAPE clause in the LIKE
condition.
Values
If this setting is not specified, Connection Server retrieves the information
from the database middleware.
Default
13.1.20 MINUS
<Parameter Name="MINUS">MINUS</Parameter>
Specifies the keyword supported by the database for the MINUS set
operation.
Description
2012-03-15168
PRM parameter reference