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.