Micro Focus Studio Enterprise Edition for Windows > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded ADO Statements > LOAD DATATABLE

LOAD DATATABLE

Loads a DataTable that has been stored as an XML file and provides addressability to the corresponding ADO.NET DataTable.

Syntax:

>>--EXEC ADO---LOAD DATATABLE datatable_name FROM ------------------->

 >--xml_file_spec--.-------------------.--.----------------------.--->
                   +-WITH SCHEMA CHECK-+  +-RETURNING :dt_obj_hv-+
 
 >--END-EXEC----><

Parameters:

`datatable_name`	The DataTable reference to be used.
`xml_file_spec`	Location of the XML file that contains the DataTable’s schema and data.
WITH SCHEMA CHECK	Verifies that the DECLARE DATATABLE used at compile time matches the one stored in the XML file.
`dt_obj_hv`	Host variable where the DataTable object is placed.

Example:

     EXEC ADO  
        LOAD DATATABLE  TABLE1 FROM "C:\DATA\EMPLOYEE.XML" 
        WITH SCHEMA CHECK RETURNING :DATATBL-OBJ  
     END-EXEC