Summary of connection types

The following table summarizes the methods that supports to connect to a database server.
Table 1. Statements and functions that start the database server

The first column is the SQL statement or ESQL/C function. The second top column has two columns underneath it for the different types of connections: Implicit and Explicit. The third top column shows Effect on a connection to the database server and underneath it two columns: Establishes a connection and Opens a database.

SQL statement or ESQL/C function Implicit Explicit Establishes a connection Opens a database
If first SQL statement in the program is:
DATABASE Y Y Y
CREATE DATABASE Y Y Y
START DATABASE Y Y Y
DROP DATABASE Y Y
sqlstart() Y Y
CONNECT TO DEFAULT Y Y
CONNECT TO '@servername' Y Y
CONNECT TO 'dbname' Y Y Y
CONNECT TO 'dbname@servername' Y Y Y