parameter

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
c341
Participant
Posts: 39
Joined: Mon Jan 26, 2004 8:43 pm

parameter

Post by c341 »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I just answered this over at ADN. Well, maybe not 'answered' so much as 'replied', but you get my drift. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply