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