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

SAVE DATATABLE

Saves the data and optionally the schema of a DataTable to an XML file.

Syntax:

>>--EXEC ADO-.--------------------.-SAVE DATATABLE datatable_name--.-------------.---> 
             +-USING dataset_name-+                                +-WITH SCHEMA-+

 >---TO----xml_file_spec---END-EXEC---><

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 DataTable reference to be used.
`xml_file_spec`	A file to contain the XML file that represents the DataTable and schema.

Example:

     EXEC ADO 
        SAVE DATATABLE TABLE1 WITH SCHEMA TO "C:\DATA\NEWEMPLOYEE.XML"  
     END-EXEC