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
vinaymanchinila
Premium Member
Posts: 353 Joined: Wed Apr 06, 2005 8:45 am
Post
by vinaymanchinila » Thu Apr 28, 2005 1:36 pm
Hi,
As our jobs would be outsourced for production support, we need to secure the IDS and PWDs for the BW plug in stage (Extract & Load). Is there a way to pass the id and pasasword as parameters. i ddi try but the job failed.
Thanks,
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Apr 28, 2005 4:18 pm
HOW did you try? Were the parameter references correctly spelled and correctly cased and enclosed in "#" characters?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vinaymanchinila
Premium Member
Posts: 353 Joined: Wed Apr 06, 2005 8:45 am
Post
by vinaymanchinila » Mon May 02, 2005 5:23 am
yes Ray, in the parameters tab I mentioned the ID and password as ParamID and ParamPWD. Inside the plug in stage I gave them as #ParamID# and #ParamPWD#.
My thing is , is it possible in the first place!
Thanks a bunch
ahmediftikhar
Participant
Posts: 22 Joined: Thu Jul 29, 2004 8:10 am
Post
by ahmediftikhar » Mon May 02, 2005 5:42 am
Can you tell what was the error message?
Are you trying with environment variable or job parameter?
vinaymanchinila
Premium Member
Posts: 353 Joined: Wed Apr 06, 2005 8:45 am
Post
by vinaymanchinila » Mon May 02, 2005 5:45 am
It is job parameter in the BW Load plug-in stage. Its says "Invalid ID and PWD"
vinaymanchinila
Premium Member
Posts: 353 Joined: Wed Apr 06, 2005 8:45 am
Post
by vinaymanchinila » Wed Jun 22, 2005 2:03 pm
Hi Al,
I got the id and pwd working by using #$ParamID# and #$Parampwd# and defining them as project env variables.
Thanks,