Using Variables to set connctions

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
JDionne
Participant
Posts: 342
Joined: Wed Aug 27, 2003 1:06 pm

Using Variables to set connctions

Post by JDionne »

I know its a good idea to set variables to use as connection information, but how do I do that with the password?
Jim
Sure I need help....But who dosent?
denzilsyb
Participant
Posts: 186
Joined: Mon Sep 22, 2003 7:38 am
Location: South Africa
Contact:

Post by denzilsyb »

Hi Jim

Try the parameters for the job in the 'job properties'. Under "Type" selct password and then the password you enter will be encrypted in the director log.

you can pass the password to the job using variables from within a job control, as long ass the parameter is set.
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Technically, under 'Type' you select 'Encrypted'. :wink: But other than that, as noted, it's just basically another Job Parameter.
-craig

"You can never have too many knives" -- Logan Nine Fingers
JDionne
Participant
Posts: 342
Joined: Wed Aug 27, 2003 1:06 pm

Post by JDionne »

chulett wrote:Technically, under 'Type' you select 'Encrypted'. :wink: But other than that, as noted, it's just basically another Job Parameter.
What do I put in the password field in the stage?
Sure I need help....But who dosent?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The name of your Job Parameter surrounded by pound signs, like 'normal'. It will be a little wierd because you won't be able to see it, but try using View Data and make sure it prompts you for the Parameter so you know it's ok.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Because you cannot see it then we cut and paste it in by putting #TargetPwd# in the description field. Saves time and mistakes.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or on stages with the older 'grid style' available (like OCI) right-click, select 'Grid Style' and then you get an 'Insert Job Parameter' helper. No typing involved. :wink:
-craig

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