Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded ADO Statements > GET CHANGES

GET CHANGES

Creates a new DataSet containing only DataRows that have been modified (deleted, added or changed).

Syntax:

>>-EXEC ADO-.--------------------.-GET CHANGES INTO— :dataset_hv---->
            +-USING dataset_name-+
              
 >--END-EXEC----><

Parameters:

`dataset_name`	The DataSet reference to be used. If you do not specify `dataset_name`, the current DataSet is used.
`dataset_hv`	Host variable where the DataSet object is placed. This DataSet only contains changed data from the source DataSet.

Comment:

Because the resultant DataSet only contains change information, it can be used (rather than the entire DataSet) to minimize network traffic when updating a data source.

Example:

     EXEC ADO
        GET CHANGES INTO :changesDSobj
     END-EXEC