Micro Focus Visual COBOL 2.3 Update 1 for Eclipse (UNIX) > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded SQL Statements > BIND CONNECTION

BIND CONNECTION

Enables a JDBC connection object to be shared with OpenESQL.

Syntax:

>>--EXEC SQL--BIND CONNECTION--.-----------------.-TO :conn_obj_hv---->
                               +-connection_name-+
                               +- :conn_name_hv -+
 >--END-EXEC----><

Parameters:

`connection_name`	The connection name OpenESQL uses to refer to the JDBC connection object.
`conn_name_hv`	Host variable which contains the connection name OpenESQL uses to refer to the JDBC connection object.
`conn_obj_hv`	Host variable where the JDBC connection object is specified.

Comments:

The named OpenESQL connection can use the existing JDBC connection and transaction objects in further EXEC SQL processing.

Example:

     EXEC SQL 
        BIND CONNECTION fred TO :con 
     END-EXEC