Page 1 of 1

Reading encrypted password parameter from value file...

Posted: Thu May 06, 2010 6:47 am
by datisaq
I am reading a parameter set value file through UNIX.The value file is having user id and encrypted password of the database.

I'm reading the user id and encrypted password from the file and passing to the dsjob command.But the job is aborting with error as "login failed: Invalid password".

Is there any other way to read the encrypted password from the value file and pass to the job??

Please help me out....

Posted: Thu May 06, 2010 7:02 am
by priyadarshikunal
use datastage to run the jobs.

Or design the sequence to read those values and pass it to child jobs. Then call the sequence from command line.

Posted: Fri May 07, 2010 1:25 pm
by nagarjuna
I believe you have given the password in the parameterset ( value file ) through datastage .If that value is not changed at unix level then you should be able to pass the value file at runtime through command line and execute the job successfully .