Try OpenEdge Now
skip to main content
Core Business Services - Security and Auditing
Transparent Data Encryption : Configuring Transparent Data Encryption policies : OpenEdge SQL support for transparent data encryption : Adding an encrypted column
 
Adding an encrypted column
You can create a new encrypted LOB column in a table by using either the CREATE TABLE or the ALTER TABLE ADD COLUMN statements with the optional ENCRYPT WITH clause. When the ENCRYPT WITH clause is specified, OpenEdge SQL creates a new encryption object policy for the new BLOB or CLOB column in the database security schema. The new column must be either a BLOB or a CLOB data type in a Type II area to be encrypted. Use the following syntax to create a new encrypted LOB column:
{ LVARCHAR | CLOB | LVARBINARY | BLOB }[ ( length ) ]
[ AREA areaname ]
[ ENCRYPT WITH cipher]
[BUFFER_POOL{PRIMARY|ALTERNATE}]