DSXchange

Hi All -

Is there a way Datastage can validate a password value in a txt file which is in encrypted format ?

My requirement is as follows,

We have a external application whose password to connect to Database(DB2) changes very often. They will store the encrypted value in a txt file. I need to decrypt this password value & use it in my Datastage job.

Is this possible ?

Thanks in advance
Sysnog

Only if you have the decryption algorithm.

DataStage can be used to compare encrypted strings. That is, one encrypted string with/against another encrypted string.

Thanks Ray.

The issue here is, the password is generated in Mainframe & they will store this file in Mainframe system. I am not sure how Datastage can interpret this decrypted value.

Thanks again
Synsog

DataStage can not "interpret" anything. All it can do is compare two strings - encrypted or otherwise - to determine whether they are the same.