The Database Server
The Database Server is used to process SQL statements received from some original and optimized clients using ODBC. In addition, the Windows 95/98/NT/2000 client UI file transfer application uses this server. It is also used by optimized clients using the Remote SQL and file transfer APIs.
The Database Server is unusual in that it looks to Network Security as if it were four different servers. Thus, when securing the Database Server you might need to enter rules for four different server names. The following table lists the Database Server functions used by the different client actions.
| Connect to the Database Server |
*SQL |
INIT |
| Create a database file |
*NDB |
CRTSRCPF CRTDBF |
| Add a member to a database file |
*NDB |
ADDDBFMBR |
| Add library list entry |
*NDB |
ADDLIBL |
| Delete a database file member |
*NDB |
DLTDBFMBR |
| Clear a database file member |
*NDB |
CLRDBFMBR |
| Override a database file |
*NDB |
OVRDBF |
| Delete database file override |
*NDB |
DLTDBFOVR |
| Delete a database file |
*NDB |
DLTF |
| Connect to a database |
*SQLSRV |
CONNECT |
| Prepare an SQL statement |
*SQLSRV |
PRPDDESCRB PRPEXCOPN PREPARE |
| Execute an SQL statement |
*SQLSRV |
EXECUTE EXECUTEIMM PRPEXCOPN EXECOPEN |
| Prepare and execute |
*SQLSRV |
PRPEXECUTE |
| Fetch rows |
*SQLSRV |
FETCH |
| Create an SQL package |
*SQLSRV |
CREATEPKG |
| Clear an SQL package |
*SQLSRV |
CLEARPKG |
| Delete an SQL package |
*SQLSRV |
DELETEPKG |
| Open an SQL cursor |
*SQLSRV |
OPEN EXECOPEN OPENFETCH PRPEXCOPN |
| Retrieve information about libraries, databases, SQL packages, and so on |
*RTVOBJINF |
RTVLIBINF RTVRDBINF RTVSQLPKG RTVSQLSTMT RTVFILINF RTVMBRINF RTVFMTINF RTVFLDINF RTVIDXINF RTVFKEYINF RTVPKEYINF RTVCLMINF |