DB2 Table Data Encryption

Example:

1. C: \> db2 create table encode_demo (col1 varchar (100) for bit data)// Field col1 data is stored in binary format The DB20000I SQL command is successfully completed. 2. C: \> db2 set encryption password = 'loveunix'// Set the encrypted and decrypted passwd The DB20000I SQL command is successfully completed. 3. C: \> db2 values (encrypt ('loveunix '))// Preview the encrypted loveunix 1 --------------------------------------------------- X '08bc44ff6a05a3d5240e86cfb2ce60f243aa83c41b7221d7' 4. C: \> db2 insert into encode_demo values (encrypt ('loveunix '))// Insert records The DB20000I SQL command is successfully completed. 5. C: \> db2 select decrypt_char (col1) as encode from encode_demo// Decrypt and retrieve records ENCODE -------------------------------------------------------------------------------- Loveunix 1 record selected.