• 2 replies
  • Latest Post - ‏2012-04-13T16:59:54Z by SystemAdmin
71 Posts

Pinned topic Data Encryption/Decryption

‏2012-04-09T06:36:48Z |

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 ?

Updated on 2012-04-13T16:59:54Z at 2012-04-13T16:59:54Z by SystemAdmin
  • nivanov1
    231 Posts

    Re: Data Encryption/Decryption

  • SystemAdmin
    17917 Posts

    Re: Data Encryption/Decryption

    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