Page 1 of 1

Sub queries and funtions not working in oracle connector

Posted: Wed Jun 22, 2011 1:32 pm
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.

Posted: Wed Jun 22, 2011 4:43 pm
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"?