Multiplex DDL restrictions [CR 367460]

Sybase IQ will not propagate CREATE, ALTER, and DROP statements for procedure and function definitions from the write server to query servers in a multiplex. You must use one of the following methods to keep procedure and function definitions consistent across multiplex servers.

• After executing the DDL statements to modify procedures and functions at the write server, execute the same statements on each query server. Create a SQL script for this approach to ensure consistent definitions.

• After executing the DDL statement(s) to modify procedures and functions at the write server, synchronize each query server.

ALTER and DROP statements for procedures and functions can fail if the existing definition is in use by another connection to the server. The user should schedule maintenance of procedures and functions for periods when the existing definitions will not be used.

This information was omitted from the Sybase IQ System Administration Guide.