The Remote SQL Server
The Remote SQL Server is used by a client to request processing of SQL statements received by PC programs using the Remote SQL API. This server is used by both the original and optimized clients when Remote SQL API requests are received. It is also used by the ODBC driver of some original clients. Other original clients and optimized clients have ODBC drivers that use the Database Server.
The following table lists the Remote SQL Server functions used by the different client actions.
| Client Action | Server Name | Server Function |
|---|---|---|
| Connect to a database | *RQSRV | CONNECT |
| Execute a SELECT SQL statement | *RQSRV | SELECT SELECTPM SELECTVAL SELECTPKG |
| Execute a non-SELECT SQL statement | *RQSRV | EXECUTE EXECUTEPM EXECPKG |
| Delete the row at the cursor | *RQSRV | DELETE |
| Update the row at the cursor | *RQSRV | UPDATE |
| Call a stored procedure | *RQSRV | RMTCALL |
| Create an SQL package | *RQSRV | CREATEPKG PREPTOPKG |