Enable Access to Encrypted Data
Access to encrypted data in a table that contains encrypted columns is possible only when it is enabled after server startup with the MODIFY statement:
MODIFY socsec1 ENCRYPT
WITH PASSPHRASE='transparent encryption example';