SAP Knowledge Base Article - Preview

2303525 - How to add multiple LOB items and store as statements in physical options

Symptom

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,
   FILECNT BLOB,
   CNT CLOB,
   MSG VARCHAR2(4000),
   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.

PhysicalOption.PNG
         
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. 


Read more...

Environment

PowerDesigner 16.5 SP05 PL05
Oracle 12c

Product

SAP PowerDesigner 16.5

Keywords

SAP Powerdesigner, Physical options, LOB, item, store as , KBA , BC-SYB-PD , PowerDesigner , Problem

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.