Additional steps required if you used 12.5.3a features before downgrading  Real Time Messaging

Release Bulletin Adaptive Server® Enterprise Version 12.5.3a for IBM AIX

Encrypted Columns

If you have used the encrypted columns feature of 12.5.3a, you must take steps in 12.5.3a before you downgrade. Perform the following:

  1. Drop all stored procedures, views, and triggers that use the SQL extensions for encrypted columns.

  2. Remove all encrypted data by dropping tables with encrypted columns or using alter table to decrypt the data or drop the encrypted columns.

  3. Run sp_encryption remove_catalog to remove the sysencryptkeys system catalog in each database.





Copyright © 2005. Sybase Inc. All rights reserved. Real Time Messaging

View this release bulletin as PDF