DROP PROCEDURE on multiplex after upgrade [CR 398236]

Attempting to drop or alter a procedure on a query server after upgrading from 12.5 to 12.6 returns a “permission denied” error.

To DROP or ALTER PROCEDURE on a multiplex upgraded to Sybase IQ 12.6, perform the following steps:

  1. On the write server, recreate the procedure. This overwrites the query server’s version. For example:

    CREATE PROCEDURE quarterly_results
    
  2. On the write server, drop the procedure, for example:

    DROP PROCEDURE quarterly_results