DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
thompsonp



Group memberships:
Premium Members

Joined: 01 Mar 2005
Posts: 204

Points: 1920

Post Posted: Tue Jul 24, 2018 7:24 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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:
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

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Tue Jul 24, 2018 7:33 am Reply with quote    Back to top    

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.

_________________

Image
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours