Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

&&tablespace in SQL scripts

I have a requirement to generate schema creation scripts which use SQLPlus substition variables for the tablespace.

Is there a way to generate SQL scripts from PowerDesigner 15.1 with &&tablespace?

I have tried the following approaches without success:

Creating a tablespace with && in the code results in the error message Invalid Code. I cannot find the valid codes that applies to tablespaces to change this.

I have tried amending the Script\Objects\Table\Options but this generates an SQL script with a space between the && and the tablespace name

Thanks in advance

Ian

Former Member
Former Member replied

Under 'Model Options'->Naming Convention, add "&" to the 'Valid Characters' list on the 'Code' tab of 'Other Objects'

Chris

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question