&&tablespace in SQL scripts

[Former Member]

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

[c_baker · Accepted solution]

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

Chris

[Former Member]

Thanks very much Chris.