How to assign $Var value to Param value
Moderators: chulett, rschirm, roy
How to assign $Var value to Param value
Hi there
Just a thought.
Is it possible to assign a $VALUE to a Parameter in the Parameter set?
For example:
I have a parameter set having LND_PWD as the parameter name.
I have a user defined variable called $LND_PWD.
Now I wish to know, is there is any way i can assign the $LND_PWD to LND_PWD in the parameter set.
Is it possible to do?
DS User
Just a thought.
Is it possible to assign a $VALUE to a Parameter in the Parameter set?
For example:
I have a parameter set having LND_PWD as the parameter name.
I have a user defined variable called $LND_PWD.
Now I wish to know, is there is any way i can assign the $LND_PWD to LND_PWD in the parameter set.
Is it possible to do?
DS User
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
I don't know.SURA wrote:Is it documented any where?DS User
If your password is encrypted type, just make sure that you enter exactly what you need. e.g. $VALUE, $ORA_PWD etc
Last edited by kandyshandy on Sun Feb 19, 2012 8:08 pm, edited 1 time in total.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
I trust there might be a gap in the way how i expressed / understanding.
Let me ask it again!!
Step 1) A parameter set is created which is having a param name called LND_PWD.
Step 2) I created a user defined variable $DB_PWD in the admin client.
In the Parameter Set (Not in the job) for the LND_PWD param i wish to get the value from $DB_PWD and not the hardcoded value.
To achieve that , if i pass #$DB_PWD# in the default value of LND_PWD will it help me to get the value from $DB_PWD (Admin)??
Or
How to do it?
When i assign the value as #$DB_PWD# in the default value of LND_PWD in the Parameter set i got the below error.
main_program: Fatal Error: Could not connect to datasource?? (-1; test; TEST; [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test'.) : [odbcUtils.C:206]
Let me know if i missed to provide any information !
Thanks
DS User
Let me ask it again!!
Step 1) A parameter set is created which is having a param name called LND_PWD.
Step 2) I created a user defined variable $DB_PWD in the admin client.
In the Parameter Set (Not in the job) for the LND_PWD param i wish to get the value from $DB_PWD and not the hardcoded value.
To achieve that , if i pass #$DB_PWD# in the default value of LND_PWD will it help me to get the value from $DB_PWD (Admin)??
Or
How to do it?
When i assign the value as #$DB_PWD# in the default value of LND_PWD in the Parameter set i got the below error.
main_program: Fatal Error: Could not connect to datasource?? (-1; test; TEST; [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test'.) : [odbcUtils.C:206]
Let me know if i missed to provide any information !
Thanks
DS User
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore