sp_iqmpxdropwriterlogin procedure [CR 421148]

An ESD #1 enhancement includes a stored procedure that drops existing external login for DBA to writer server.

call sp_iqmpxdropwriterlogin 

sp_iqmpxdropwriterlogin 

DBA authority required.

Used to drop an existing external login for DBA to write server. To change the external login, call sp_iqmpxcreatewriterlogin before calling the sp_iqmpxcreatewriterlogin procedure.

The following errors might occur. Causes are listed after each error.

"Permission denied: you do not have permission to
execute the procedure "sp_iqmpxdropwriterlogin"

Cause: A user without DBA privilege tried to execute the sp_iqmpxdropwriterlogin procedure.

"RAISERROR executed: The stored procedure is not called
from a query server. Sybase error code=17823,
SQLState="WW012"

Cause: This procedure can only be called from a query server.

"ASA Error -712: External login for server
'SYBIQ_MpxRemoteWriter' could not be found Sybase Error
code=11221, SQLState="WO013"

Cause: The external login does not exist or has already been dropped.