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.
Pinned topic Data Encryption/Decryption
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
nivanov1 100000H9H7231 Posts
Re: Data Encryption/Decryption2012-04-09T16:35:33ZThis is the accepted answer. This is the accepted answer.http://www-01.ibm.com/software/data/guardium/encryption-expert/
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