Disconnected Model Statements

Disconnected model statements enable you to define, create and manipulate ADO.NET objects in COBOL. They are commonly used to:

• Define DataTables and their relationships to each other within a DataSet
• Insert, update and delete DataRows in a DataTable
• Select DataRows from a DataTable
• Clear DataTables in a DataSet
• Commit or rollback pending changes in a DataSet
• Load an existing XML DataSet file into a COBOL DataSet
• Save a DataSet to a file in XML format.

The following disconnected model statements are available to you:

• BIND DATATABLE – allows an ADO.NET DataTable to be shared with OpenESQL
• BIND DATASET – allows an ADO.NET DataSet to be shared with OpenESQL
• CLEAR - clears the data in specified DataTables of a DataSet
• DECLARE DATATABLE – defines a DataTable
• DECLARE DATASET – defines a DataSet
• GET DATATABLE – copies a DataTable object into a host variable or creates a DataTable object within a host variable
• INITIALIZE DATATABLE – creates a DataTable
• INITIALIZE DATASET – creates a DataSet
• INSERT – adds DataRows into a DataTable
• DELETE (SEARCHED) – deletes DataRows from a DataTable
• UPDATE (SEARCHED) – updates DataRows in a DataTable
• SELECT INTO – retrieves DataRows from a DataTable
• CLEAR – clears the DataTables in a DataSet
• ACCEPT CHANGES – commits pending changes to a DataSet.

  Note that, this statement does not commit changes to a database. To commit changes to a database, you must use the connected model to synchronize the DataSet with the database and then use the EXEC SQL COMMIT statement.

• REJECT CHANGES – rolls back pending changes made to a DataSet.

  Note that, this statement does not roll back changes made to a database. To roll back changes in a database, you must use the connected model to synchronize the DataSet with the database and then use the EXEC SQL ROLLBACK statement.

• LOAD DATATABLE – loads a DataTable from an XML file
• LOAD DATASET – loads a DataSet from an XML file
• SAVE DATATABLE – saves a DataTable to an XML file
• SAVE DATASET – saves a DataSet to an XML file
• MERGE DATATABLE – merges two similar DataTables together
• MERGE DATASET – merges two similar DataSets together
• UNBIND DATATABLE – disassociates OpenESQL from a DataTable in another ADO.NET application
• UNBIND DATASET – disassociates OpenESQL from a DataSet in another ADO.NET application
• USING – defines a default DataSet for EXEC ADO processing