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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.