Creating views with column-level encryption
You can create a view that uses column-level encryption and selects decrypted data from a table.
About this task
You can define the view with a decryption function in the defining fullselect. If the correct password is provided when the view is queried, Db2 will return decrypted data. Suppose that you want to create a view that contains decrypted employee ID numbers from the EMP table.
Procedure
To create a view that uses column-level encryption and selects decrypted data: