&&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
Under 'Model Options'->Naming Convention, add "&" to the 'Valid Characters' list on the 'Code' tab of 'Other Objects'