How to set default options in PD 16.5 SP03 PL01

[Former Member]

Everyone,

I want to set some default physical options while reverse engineering the table(s).

I want following options to be added everytime I reverse engieer the table.

CREATE MULTISET TABLE,

NO FALLBACK ,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT,

DEFAULT MERGEBLOCKRATIO

This is what we are going to use most of the time, so I dont want to create a table and then goto physical options and choose them. I want this by default. However in rare cases we might be using some other options as well like CREATE SET TABLE, so I should be able to change it whenever I want but default properties should be listed above.

Is there a way I can do this?

Thanks,

Perry

[Former Member · Accepted solution]

Event handler "AfterDatabaseReverseEngineer" for "model" metaclass may help.

Adding Scripts Before or After Database Generation and Reverse Engineering

To set default physical options when table created manualy in PD, model default physical options can be used or "Initialize" event handler of table can be an alternative.