Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded ADO Statements > REBIND CONNECTION

REBIND CONNECTION

Informs OpenESQL that a shared connection transaction has been terminated and supplies a new transaction object for subsequent processing.

Syntax:

>>--EXEC ADO---REBIND CONNECTION--.-----------------.----->
                                  +-connection_name-+
                                  +-:conn_name_hv---+
 
 >--WITH +-TRANSACTION-+  :tran_obj_hv---END-EXEC--------->< 
         +-TRAN       -+

Parameters:

`connection_name`	The connection name OpenESQL uses to refer to the ADO.NET connection object.
`conn_name_hv`	Host variable that contains the connection name OpenESQL uses for the ADO.NET connection object.
`tran_obj_hv`	Host variable that contains the new ADO.NET transaction object that OpenESQL is to use.

Comment:

If the transaction object is NULL, then the connection enters AUTOCOMMIT mode.

Example:

     EXEC ADO 
        REBIND CONNECTION WITH TRANSACTION :tran
     END-EXEC