Hi Everyone,

I need help in encrypting data in db2.

I need to encrypt account no and store as a different number (random number) in table accounts. again i have to decrypt the stored number.

I tried the encrypt func in db2 but it is not storing the encrypted value in the table. Please advice.