SAP Knowledge Base Article - Preview

2929824 - DDLGEN generates create table script with a 'lob_compression=' clause with no value - SAP ASE

Symptom

  • Executing a CREATE TABLE script generated by DDLGEN fails with error message 156 state 2 "Incorrect syntax near the keyword 'on'".
  • DDLGEN outputs a CREATE TABLE script that is missing the value for the lob_compression clause:
    Example:
    [...]
    lock datarows
    with dml_logging = full
    , lob_compression =
    on'default'


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE)
  • DDLGEN 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Sybase, ASEServer, SAPASE, dataserver, ddlgen, CR701471 , CR#701471 , 701471 , syntax error, keyword, lob_compression , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

About this page

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

Search for additional results

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