sp_regnowatch

Remove a client from the notification list for a procedure.

sp_regnowatch proc_name

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.