SAP Knowledge Base Article - Preview

2461133 - Enabling table compression sets all columns to "not compressed" - SAP PD

Symptom

  • Create a compressed table for ASE: all columns are specified as not compressed.
  • Executing the SQL script generated by SAP PowerDesigner leads to error:

1> create table TABLE_1 (
COLUMN_1 char(10) null not compressed,
COLUMN_2 char(10) null not compressed,
COLUMN_3 char(10) null not compressed
)
with compression = row
go
Msg 1790, Level 16, State 1:
Server 'ServerName', Line 1:
Table 'TABLE_1' cannot be compressed; none of the columns are compressible.


Read more...

Environment

  • PowerDesigner 16.6
  • SAP AS Enterprise 16.0
  • Sybase AS Enterprise 15.7

Product

SAP PowerDesigner all versions

Keywords

adaptive, 807440, CR807440, CR#807440 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.