A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
kamalshil
Participant
Posts: 179 Joined: Mon Jun 23, 2008 1:19 am
Post
by kamalshil » Mon Feb 08, 2010 3:29 am
Hi All,
I am trying to call 1 stored procedure from datastage job.
But if in any of feild for database,password,username or schemaname if i give job parameter.
i am getting fatal error.
TNS-ORA-Could not resolve.
And if i do hard coding it is working fine.
So how do i use job parameters in stored procedure stage?
bmarko22
Participant
Posts: 21 Joined: Mon Nov 16, 2009 7:03 am
Location: MD
Post
by bmarko22 » Mon Feb 08, 2010 7:26 am
If you have the parms in quotes take them out. Fixed it for us.
kamalshil
Participant
Posts: 179 Joined: Mon Jun 23, 2008 1:19 am
Post
by kamalshil » Mon Feb 08, 2010 7:31 am
No they are not in quotes
they are like this
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Feb 08, 2010 8:20 am
And you actually have a job parameter defined in the job named '$username' - all lower-case, just like that?
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Feb 08, 2010 3:29 pm
The "$" character will cause DataStage to seek out an environment variable in the project. Is that how your project is set up?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kamalshil
Participant
Posts: 179 Joined: Mon Jun 23, 2008 1:19 am
Post
by kamalshil » Tue Feb 09, 2010 12:24 am
ray.wurlod wrote: The "$" character will cause DataStage to seek out an environment variable in the project. Is that how your project is set up? ...
Yes.
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Tue Feb 09, 2010 5:29 am
Do you get an oracle error code ?
Include a command stage to echo the value for oracle connection string.