Jop Parametre

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
koojo
Premium Member
Premium Member
Posts: 43
Joined: Sun Jul 11, 2004 1:30 pm
Location: USA

Jop Parametre

Post by koojo »

Jobs are set up in the following order

Sequencer_One ---> Calls -----> Sequencer_Two, Sequencer_Three.........

Sequencer_Two----->Calls------->Job_1 , Job_2........


All variables are $PROJDEF and set up correctly in the administartor.

All the user name passwords are passed in correctly for oracle (OCI stage) ----> from Sequencer_One to Sequencer_Two to Job_1.

However when I check the password being passed for OCI stage is encrypted and is not passed correctly in Job_1. However it is set up correctly in Sequencer_Two. From Sequencer_one to Sequencer_Two the password (encrypted) is passed in correctly. :evil:


Is there something I am missing out here :?: . Or could this be a bug.
Amos.Rosmarin
Premium Member
Premium Member
Posts: 385
Joined: Tue Oct 07, 2003 4:55 am

Post by Amos.Rosmarin »

Hi,

I guess you miss something since it is working fine for me.
There are stges like 'nested condition' that do not like parameters but I never had problems passing parameters from sequencer to a job.
Use string for pwd and if it works ok change the parameter type to encrypted.



HTH,
Amos
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Yes it does happen some times :(
You'll need to retype your password and recompile.
This situation might also occur in schedualed jobs - reschedual them and in the schedual retype your parameters.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
koojo
Premium Member
Premium Member
Posts: 43
Joined: Sun Jul 11, 2004 1:30 pm
Location: USA

Post by koojo »

Thank you Roy but it wont let me type in anything (guess that is because the parametre is encrypted) but i can use insert parametre. And sequencer_one is scheduled. Thats what I did....Hope it works this time.
Post Reply