Interact with the database server
Within your program,
you can interact with the database server in the following ways:
- Start a new database server process. This process does not exist when an application begins execution.
- Switch between multiple connections. An application can establish several connections.
- Identify an explicit connection. An application can obtain the name of the database server and connection.
- Identify the databases that the database server of the current connection can access.
- Check on the status of the database server process. For some actions the database server must be busy, for others the database server must be idle.
- Detaching from the current connection. An application must detach a child process from the current connection.
- Interrupt the database server process. If an SQL request executes for a long time, the application can interrupt it.
- Terminate the database server process. The application can close an unused connection to free resources.