Remove a client from the notification list for a procedure.
sp_regnowatch proc_name
The name of the registered procedure.
dbrpcinit(dbproc, "sp_regnowatch", (DBUSMALLINT)
0);
dbrpcparam(dbproc, "@proc_name", 0, SYBCHAR, 15,
15, "pricechange");
dbrpcsend(dbproc);
This example removes the client from the notification list for the pricechange registered procedure.
This registered procedure executes when a client calls dbregnowatch.
A SRV_C_PROCEXEC callback handler can use srv_rpcname to determine that sp_regnowatch is executing and sp_paramdata to obtain the name of the procedure for which the notification request is to be removed.
Notification request removed.
The notification request was removed successfully.
proc_name is not a registered procedure.
The procedure specified by proc_name is not registered in Open Server.
No requests pending.
The client had no notification requests pending for the procedure.
Unable to remove notification request.
Open Server failed to remove the notification request.
sp_regcreate, sp_regdrop, sp_regwatch, sp_regnowatch, sp_regwatch