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 ?
This topic has been locked.
2 replies Latest Post - 2012-04-13T16:59:54Z by SystemAdmin
Pinned topic Data Encryption/Decryption
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-04-13T16:59:54Z at 2012-04-13T16:59:54Z by SystemAdmin
SystemAdmin 110000D4XK17917 PostsACCEPTED ANSWER
Re: Data Encryption/Decryption2012-04-13T16:59:54Z in response to deepaksamalyou 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