Every Open Server application contains built-in registered procedures, called system registered procedures. The runtime system creates them when the server starts up. The system registered procedures are described in Chapter 4, “System Registered Procedures” Some of these procedures are useful for administering an Open Server application interactively. For example, you can use sp_who and sp_ps to list active server processes and sp_terminate to destroy a process.
Client applications can execute system registered procedures to perform the following operations:
Get a list of registered procedures
Execute a registered procedure
Request notification of a registered procedure’s execution
Get a list of notification requests
Most system registered procedures map to an equivalent Open Server routine. An Open Server application and a client can request the same kind of information through distinct routines.
Table 2-34 matches each system registered procedure to the corresponding Server-Library routine, if applicable:
System registered procedure |
Server-Library routine |
|---|---|
sp_ps |
N/A |
sp_regcreate |
srv_regcreate/srv_regdefine |
sp_regdrop |
srv_regdrop |
sp_reglist |
srv_reglist |
sp_regnowatch |
srv_regnowatch |
sp_regwatch |
srv_regwatch |
sp_regwatchlist |
srv_regwatchlist |
sp_serverinfo |
N/A |
sp_terminate |
srv_termproc |
sp_who |
N/A |
