PD doesn't allow to add multiple LOB store as statements.
Below is a table's DDL to be generated.
CREATE TABLE TEST(
ID NUMBER NOT NULL,
CONSTRAINT TESTPK (ID)
LOB (FILECNT) STORE AS BASICFILE (TABLESPACE TS_BLOB)
LOB (CNT) STORE AS BASICFILE (TABLESPACE TS_CLOB) ;
When trying to add the second LOB item and store as statement, the second one is not added to tree of the physical options.
In case of reverse engineering from a file containing the whole DDL statement, it can be seen correctly from the Physical Options-SQL tab as designed.
But, there is just one LOB store as statement in the Physical Options-Items tab.
It seems like PD shares the store as statement from multiple LOB items.
PowerDesigner 16.5 SP05 PL05
SAP Powerdesigner, Physical options, LOB, item, store as , KBA , BC-SYB-PD , PowerDesigner , Problem
About this pageThis 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.