The following rules govern DDL operations on multiplex databases:
You must use Sybase Central to add main and temp dbspaces, as described in “Adding a main dbspace to a multiplex” and “Adding a temporary dbspace to a multiplex”.
You can create and populate Adaptive Server Anywhere tables and local IQ Temporary stores, but on query servers, the effect of these operations is lost the next time you do a synchronize operation. IQ temporary tables are lost on every disconnect.
If you create objects in the SYSTEM dbspace, they are created in the Catalog Store, an Adaptive Server Anywhere (ASA) store. Anything created in SYSTEM on a query server is lost the next time you synchronize.
Exceptions to these rules are noted in Table 5-8.
To create or drop objects in the IQ Store, such as tables or indexes, you must:
Create or drop triggers or events on the write server only.
With a few exceptions, IQ multiplex databases support the same SQL statements as non-multiplex databases.
If you create objects in the SYSTEM dbspace, they are created in the Catalog Store, an Adaptive Server Anywhere (ASA) store. Anything created in SYSTEM on a query server is lost the next time you synchronize.
