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:
userid IDENTIFIED BY password
userid USING password
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.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.