Configure Clauses
On the Clauses subtab, you can change the native expression and designate unsupported native and TDV data types for each type of SQL clause. Clauses can be marked as unsupported by clearing the native expression field for it, either in the adapter configuration or in the data source overrides.
Native Expression
Type a representative syntax for the expression as it is to be pushed to the data source. In most cases the native expression already filled in does not need to change.
Unsupported Native Types
Type a comma-separated list of native (to the data source) data types that are not supported for this clause.
Unsupported TDV Types
Type a comma-separated list of unsupported TDV data types. A column or value of such types cannot appear in this clause. For example, the data source cannot do a UNION between two CLOB values.