Previous Topic Next topic Print topic


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
Previous Topic Next topic Print topic