GET CURSOR

Places a DataReader or a DataSet ADO.NET object used by the OpenESQL EXEC SQL cursor into the supplied host variable such that the object can then be shared with other ADO.NET programs.

Syntax:

>>--EXEC ADO---GET CURSOR cursor_name INTO :cursor_obj_hv-------->

 >---.------------------------------------------.---------------->
     +--RENAME DATATABLE AS new_datatable_name--+
 
 >--END-EXEC----><

Parameters:

cursor_name Name of an EXEC SQL cursor.
cursor_obj_hv Host variable where the OpenESQL ADO.NET object will be placed.
new_datatable_name The new name of the underlying DataTable in the cursor.

Purpose:

If the ADO.NET object is a DataSet, then the DataTable containing the data for the cursor can optionally be renamed. The default name, if no renaming is undertaken, is "Table".

Example:

     EXEC ADO
        GET CURSOR CSR5 INTO :ws-dataset
     END-EXEC