How to assign $Var value to Param value

SURA · Post by **SURA** » Thu Feb 16, 2012 9:37 pm

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

kandyshandy · Post by **kandyshandy** » Thu Feb 16, 2012 11:51 pm

Yes. it is.

SURA · Post by **SURA** » Thu Feb 16, 2012 11:55 pm

Thanks for the response.

Is it documented any where?

DS User

kandyshandy · Post by **kandyshandy** » Fri Feb 17, 2012 12:30 am

SURA wrote:Is it documented any where?DS User

I don't know.

If your password is encrypted type, just make sure that you enter exactly what you need. e.g. $VALUE, $ORA_PWD etc

SURA · Post by **SURA** » Sun Feb 19, 2012 5:30 pm

If you password is encrypted type, just make sure that you enter exactly what you need. e.g. $VALUE, $ORA_PWD etc

Thanks again for your comment.

I already tried like $LND_PWD , but unfortunately it is not working for me!

DS User

kandyshandy · Post by **kandyshandy** » Sun Feb 19, 2012 8:10 pm

It's not working...

then tell us what's happening or what error you are facing? did you check the director log to see what's getting passed actually?

v2kmadhav · Post by **v2kmadhav** » Mon Feb 20, 2012 2:16 am

are you saying you need $LND_PWD to be the value of the paramter LND_PWD .... it wont be possible. You could create a user defined variable $LND_PWD and call that as a paramter in your paramset.

SURA · Post by **SURA** » Mon Feb 20, 2012 6:17 pm

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

kandyshandy · Post by **kandyshandy** » Mon Feb 20, 2012 8:29 pm

SURA wrote: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)??

Don't use #. Just pass $DB_PWD in the default value. You are all set.

SURA · Post by **SURA** » Mon Feb 20, 2012 9:14 pm

No luck Kandy.

DS User

kandyshandy · Post by **kandyshandy** » Mon Feb 20, 2012 9:29 pm

Try $PROJDEF

SURA · Post by **SURA** » Mon Feb 20, 2012 9:31 pm

Just i got an email from IBM in this regards. IBM confirmed; we cant do this. So it may not be possible at this moment. If any of you did this, please share the details with me.

Thanks
DS User

kandyshandy · Post by **kandyshandy** » Mon Feb 20, 2012 9:36 pm

oh..

Job aborted with some error and that's fine. Did you check what is actually passed to the job at the first place? I am asking you this for the second time

SURA · Post by **SURA** » Mon Feb 20, 2012 9:44 pm

sorry Kandy

I fails to add that info.

It is passing the value as it is: $DB_PWD

Thanks
DS User

SURA · Post by **SURA** » Sun Feb 26, 2012 5:54 pm

IBM conlcuded, cant pass the $VALUE to a PARAM VALUE in the Parameter set.

Thanks to all.

DS User