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---->
            +-USING dataset_name-+                                      

 >-+-INTO :datatable_hv---------+---END-EXEC---------><
   +-CHANGES INTO :datatable_hv-+

Parameters:

`dataset_name`	The name of the DataSet to be used, or – (dash), which specifies a standalone DataSet. If you do not specify `dataset_name`, the current DataSet is used.
`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