Hello again.
Again, I am trying to set some standards at my job.
Here is the case:
I have bunch of parameters for a job. Parameters would be for odbc connections (db connection, user id, password). This job is generic, means that I will be calling this job at command line for different databases.
Is there any way I can pass the job level parameters at command line so that it knows which db to connect to using what id and password?
We don't want to put this info (db, id, pass) in parameter due to security reason. I agree, that would be a way to do it. But we are required to encrypt the id/pass....
All your suggestions are helpful...
Thanks in advance.
Pass a job level parameter at command line for running a job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 82
- Joined: Tue Jan 22, 2008 10:37 am
- Location: UK
You pass the name and value to dsjob: -param param=value
But this will not satisfy your requirement to hide the values.
In an 8.x ParameterSet, the values can be passed from a ParameterValue file, but still not hidden as you require.
Is there a problem with the encryption DataStage uses for passwords ?
But this will not satisfy your requirement to hide the values.
In an 8.x ParameterSet, the values can be passed from a ParameterValue file, but still not hidden as you require.
Is there a problem with the encryption DataStage uses for passwords ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We are using encrypted values in parameters.
We have about 25 sources and few targets. We have designed a job that we want to run on each source and a target. That way we have only one job to maintain. Now I want to call the job/run the job at command line using the parameters (command line paramters) that will tell the job which job level parameter (like data connection, user id, password).
Did I explain better/confused you guys again? Hope not..
We have about 25 sources and few targets. We have designed a job that we want to run on each source and a target. That way we have only one job to maintain. Now I want to call the job/run the job at command line using the parameters (command line paramters) that will tell the job which job level parameter (like data connection, user id, password).
Did I explain better/confused you guys again? Hope not..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Set the encrypted environment variable in the Administrator.
Set up the job parameter so that its default value is the special token $PROJDEF - this tells DataStage to use the project value you set up in the Administrator.
Don't mention the job parameter in your dsjob command.
Set up the job parameter so that its default value is the special token $PROJDEF - this tells DataStage to use the project value you set up in the Administrator.
Don't mention the job parameter in your dsjob command.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Still a little lost on exactly what part you are having problems with.
Are you just trying to find out the parameter names in use in any given job from the command line? You can use 'dsjob' with the '-lparams' option. Do you need the values associated with any given parameter? Then the '-paraminfo' option with the found parameter name(s).
Then your script can take that information and whatever it is you need to do with it to build a proper command string.
Are you just trying to find out the parameter names in use in any given job from the command line? You can use 'dsjob' with the '-lparams' option. Do you need the values associated with any given parameter? Then the '-paraminfo' option with the found parameter name(s).
Then your script can take that information and whatever it is you need to do with it to build a proper command string.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers