Micro Focus Studio Enterprise Edition for Windows > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded ADO Statements > GET DATATABLE

GET DATATABLE

Copies a DataTable object into a host variable or creates a DataTable object within a host variable, enabling you to share the DataTable object with other .NET languages.

Syntax:

>>-EXEC ADO---GET DATATABLE datatable_name-+-INTO :datatable_hv---------+---END-EXEC---------><
                                           +-CHANGES INTO :datatable_hv-+

Parameters:

`datatable_name`	The ADO.NET DataTable object to be shared
INTO	Copy a DataTable object into a COBOL host variable
CHANGES INTO	Create a new DataTable object that contains only the DataRows that have been modified (deleted, added or changed).
`datatable_hv`	Host variable where the DataTable object is placed.

Comment:

When you create a DataTable object, the new object contains only changed information rather than the entire DataTable. This can minimize network traffic when updating a data source.

Example:

     EXEC ADO 
        GET DATATABLE TABLE1 CHANGES INTO :HV-CHGS  
     END-EXEC