Previous Topic Next topic Print topic


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