Hi
I'm creating tables in Oracle....and the metadata is imported to datastage..
In Oraoci stage i'm using fully generated query....
The query shows the table as 'owner.tablename'
now i want use the paratmeter as the owner name...
Eg:
Table defintion-----abcdef ( properties shows the table name and DSN and owner, etc..)...in the owner name we have 'xyz'.
While i generate query ...i got..
"Select a,b,c From xyz.abcdef"
i'need this query to be as..."Select a,b,c From #owner#.abcdef".......
If i use user-defined query....there is no problem..
Thank You
c341