Enabling or disabling compression for a session does not change the compression level for existing data.
Updated rows remain uncompressed. The SAP ASE server uncompresses any compressed rows during the update.
If set compression is set to off, commands that require a data copy (for example, reorg rebuild and alter table) uncompress data rows.
After you configure set compression on, subsequent updates use the partition or tables’ compression level.