Micro Focus Visual COBOL 2.3 Update 2 for Eclipse (Windows) > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded SQL Statements > GET CONNECTION

GET CONNECTION

Places an OpenESQL connection object into the supplied host variable such that the objects can then be shared with other JDBC programs.

Syntax:

>>--EXEC SQL---GET CONNECTION--.-----------------.--INTO :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 current OpenESQL JDBC connection object is placed.

Example:

     EXEC SQL 
        GET CONNECTION INTO :con
     END-EXEC