Summary of connection types
The following table summarizes the methods that IBM®
Informix® ESQL/C supports
to connect to a database server.
| 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 |