Hi,
I want to use userdefined environment variable into the dsjob command.
Consider I declared 3 userdefined environment variables into the project
ex:- 1) $LegacyDBUserID 2) $LegacyDBPwd 3) $DBServer20.
They are having content userid, password and server name respectively.
I want pass these 3 userdefined environment variables with dsjob command for my Teradata_Login job.
I'm using following command, but it's not working.
dsjob -run -mode NORMAL -param UId=$LegacyDBUserID -param Password=$LegacyDBUserID -param Server=$LegacyDBUserID Datawarehouse Teradata_Login
If anybody having idea. Let's share with me !
Thanks,
Vivek
How to Use Userdefine Environment Variables into the Dsjob c
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Thu Feb 22, 2007 12:39 pm
- Location: Mumbai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What does "not working" mean in this context?
What error message is generated?
Why are you setting $LegacyDBUserID for each of the three parameters? That's almost certain not to be correct.
Have you proven that each of these environment variables is set?
For example
Have you tried isolating the environment variables?
For example
What error message is generated?
Why are you setting $LegacyDBUserID for each of the three parameters? That's almost certain not to be correct.
Have you proven that each of these environment variables is set?
For example
Code: Select all
echo $LegacyDBUserID
For example
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.
-
- Participant
- Posts: 30
- Joined: Thu Feb 22, 2007 12:39 pm
- Location: Mumbai
Hi,ray.wurlod wrote:What does "not working" mean in this context?
What error message is generated?
Why are you setting $LegacyDBUserID for each of the three parameters? That's almost certain not to be correct.
...
I made few changes. Now I'm trying to use these Userdefined environment variables with dsjob command.
I want to use userdefined environment variable into the dsjob command.
Consider I declared 3 userdefined environment variables into the project
ex:- 1) $LegacyDBUserID 2) $LegacyDBPwd 3) $DBServer20.
They are having content userid, password and server name respectively.
I want pass these 3 userdefined environment variables with dsjob command for my Teradata_Login job.
I'm using following command, but it's not working.
dsjob -run -mode NORMAL -param UId=$LegacyDBUserID -param Password=$LegacyDBPwd -param Server=$DBServer20 Datawarehouse Teradata_Login
Also I want to change these userdefined environment variables for each run. in the next run I will use $SalesDBUserID, $SalesDBPwd & $DBServer20.
If anybody having idea. Let's share with me !
Thanks,
Vivek
-
- Participant
- Posts: 30
- Joined: Thu Feb 22, 2007 12:39 pm
- Location: Mumbai
Thanks for your replay.mahadev.v wrote:Set these variable values to "$PROJDEF" in the job. Then you dont have to specify them in dsjob command. Every time the job is run the project level value of the variable is taken.
In the next run I want to use $SalesDBUserID, $SalesDBPwd & $DBServer20 with Teradata_Login Job.
The Teradata_Login job just login into the database and verfiying the userid for access rights ! Similary in the next run It will pickup another userdefined environment variable example $ProductDBUserID, $ProductDBPwd, $DBServer20.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The only way you can specify different environment variable names IS to specify different environment variable names.
Otherwise you'd need to create a reference to something that contains the new environment variable name, and a means of evaluating that reference so as to decode the environment variable.
And if I showed you how to do that, you'd demand yet another level of abstraction! And that way leads to insanity.
Otherwise you'd need to create a reference to something that contains the new environment variable name, and a means of evaluating that reference so as to decode the environment variable.
And if I showed you how to do that, you'd demand yet another level of abstraction! And that way leads to insanity.
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.
The first idea to share with you is to answer Ray's first two questions. All you've done here is repeat the fact that "it's not working" which doesn't help us help you.Vivek Vazarkar wrote:<snip>ray.wurlod wrote:What does "not working" mean in this context? What error message is generated?
I'm using following command, but it's not working.
<snip>
If anybody having idea. Let's share with me !
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers