Use the CONNECT statement to connect to the database instance, and specify the user name, password, and options for the database session.
EXEC SQL CONNECT
[<user_name> IDENTIFIED BY <password> |
<uidpwd>]
AT
<session_name>
USING
<database_server-database_name>
[<connect_option>...] [KEY <key>];
<uidpwd> ::= <user_name>/<password>
<connect_option> ::= [ISOLATION LEVEL <unsigned_integer>]
[TIMEOUT <unsigned_integer>]
· Choose a name for the database name in <session_name>. The only limit on the possible number of parallel database sessions in the SQL mode ORACLE is the maximum possible number of database sessions of the database instances.
· The user name <user_name> and password <password> can also be specified as a character string in a host variable (character or UNICODE data types).
· In <connect_option> you can specify an isolation level and timeout value.
· You can specify the <key> in a host variable with data type char . You can specify an XUSER user key, DEFAULT or the environment variable SQLOPT . For information on setting the connection options at runtime in this environment variable, see your operating system documentation.
· The <key> values complete or override the explicitly specified user name, password, and CONNECT options.