SQL function in update statement using ODBC connector

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
thompsonp
Premium Member
Premium Member
Posts: 205
Joined: Tue Mar 01, 2005 8:41 am

SQL function in update statement using ODBC connector

Post by thompsonp »

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:

Code: Select all

WHERE lower(entry_status)=ORCHESTRATE.entry_status
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.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

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.
Post Reply