CONNECT statement syntax enhancements
You can specify additional CONNECT statement syntax, when you set the precompiler option COMPATIBILITY_MODE to ORA.
In your C and C++ embedded SQL applications, a database connection
can be established with one of the following CONNECT statements:
EXEC SQL CONNECT TO dbname;EXEC SQL CONNECT TO dbname USER username USING password;
When you set the precompiler option COMPATIBILITY_MODE to ORA,
you can also specify the following CONNECT statement syntax:
EXEC SQL CONNECT [ username IDENTIFIED BY password ][ USING dbname ] ;The parameters are described in the following table:
| Parameter | Description |
|---|---|
| username | Either a host variable or a string that specifies the database user name |
| password | Either a host variable or a string that specifies the password |
| dbname | Either a host variable or a string that specifies the database name |