we are planning to Encrypt/Decrypt DB2 data for our product. I read some document and found that we can use Encrypt / Decrypt_Char function to do the same. But for this i need to change all my code (sqls) to support this. is there any way i can implement this with out changing sql code. tomorrow if i want to Encrypt this for 2 more table, is it possible to just implement this in the DB lavel without touching my code in the application ?
SystemAdmin 110000D4XK17917 Posts
Re: Data Encryption/Decryption2012-04-13T16:59:54ZThis is the accepted answer. This is the accepted answer.you could try something like this, although it might get too complex at some point:
create triggers on the table that do the encryption
create a view on the table that does the decryption
now, you don't have to change any of your code and everything is done at the database level behind the scenes