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

CLEAR

Clears the data in the specified DataTables of a DataSet.

Syntax:

>>--EXEC ADO---.--------------------.—CLEAR------------>
               +-USING dataset_name-+

 >-------------+-ALL DATATABLES-+---------------------->
               | +- ,        -+ |
               | V            | |
               +-datatable_name-+

 >--END-EXEC----><

Parameters:

`dataset_name`	The DataSet reference to be used. If you do not specify `dataset_name`, the current DataSet is used.
`datatable_name`	A list of the DataTables to be cleared.

Example:

     EXEC ADO
        CLEAR ALL DATATABLES
     END-EXEC