Micro Focus Studio Enterprise Edition for Windows > 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--.-------------.---> 
                                             +-WITH SCHEMA-+

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

Parameters:

`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