Sub queries and funtions not working in oracle 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
vinodshinde369
Participant
Posts: 7
Joined: Tue Dec 21, 2010 4:30 am
Location: Pune

Sub queries and funtions not working in oracle connector

Post by vinodshinde369 »

Hi All,
We have just done the installion of Datastage Px v8.5. I am trying to write a simple select subquery in oracle connector, its giving me a warning that oracle connector does not support subqueris. Also same warning giving for some simple funtions like trim, upper etc...
Is any perticular patch is required to fix this ?
Please guide...........

Thank you.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Ignore the warnings if they're occurring at design time. You'll also get warnings if you built or use user-defined SQL that contains parameter references.

What do you mean by "not working"?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply