By default tables are created as SET. Is there any option to change this setting to MULTISET as default ?
May be in DBS Control or anywhere else ?
As fa as I know the only way to get a MULTISET default is to switch Session Mode to ANSI.
But then lots of queries will not work/return a "wrong" result due to case sensivity issues.
So, i guess this is related to the session mode rather than any general DBS Control setting.