OpenEdge SQL Data Definition Language supports Transparent Data Encryption. The new functionality provides only the DBA or security administrator with the ability to:

  • Define encryption specifications for new tables, indexes, and LOB columns
  • Modify encryption or decryption specifications for existing tables, indexes, and LOB columns
  • Drop existing encrypted tables, indexes, and LOB columns
  • View encryption specifications for tables, indexes, and LOB columns
  • Rekey existing encrypted tables, indexes, and LOB columns

Note that the tables, indexes, and LOB columns must be in a Type II storage area. For details on the modified SQL syntax, see OpenEdge Data Management: SQL Development and OpenEdge Data Management: SQL Reference.