One connects to a database using the following statement:
EXEC SQL CONNECT TO target [AS connection-name] [USER user-name];
The target can be specified in the
following ways:
There are also different ways to specify the user name:
The userid and
password may be a constant text, a
character variable, or a character string.
The connection-name is used to handle
multiple connections in one program. It can be omitted if a
program uses only one connection.