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
