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:
Code: Select all
WHERE lower(entry_status)=ORCHESTRATE.entry_status
"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.