DSXchange

I have a job whose target stage is an ODBC Connector.
It will update one column on a table based on the key field.
However the SQL needs to have a LOWER function applied within the WHERE clause:
Although this works the "lower" function causes DataStage to log a warning:
"Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed"

Any idea how to prevent the warning without using a message handler or removing the lower function?

I've had similar issues with functions in the select list but these can be resolved by aliasing back to the column name. However I can't use an alias in the WHERE clause.

I'm afraid that you will get this Problem when using a function call. This is a case where a Job Level message handler can be used - to deprecate a warning that is otherwise unavoidable.

If you don't wish to do this, you would Need to add a new column to the table with the LOWER() value applied to that column.