Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
Generated EXEC ADO Statements
OpenESQL Assistant can generate the following types of EXEC ADO auxiliary code. For a description of each, see the section Using Embedded EXEC ADO Statements in the chapter Using OpenESQL with ADO.NET.
Connected or Disconnected Models
- DECLARE DATASET
- DECLARE DATATABLE
- GET CHANGES
- INITIALIZE DATASET
- UNBIND DATASET
Disconnected Models
- ACCEPT CHANGES
- BIND DATASET
- BIND DATATABLE
- CLEAR
- DECLARE DATATABLE
- DECLARE UNTYPED DATASET
- GET DATATABLE
- INITIALIZE DATASET
- INITIALIZE DATATABLE
- LOAD DATASET
- MERGE DATASET
- REJECT CHANGES
- SAVE DATASET
- SAVE DATATABLE
- UNBIND DATASET
- UNBIND DATATABLE
- USING DATASET
- Generic SQL Program
Generates a skeleton SQL program that includes the INCLUDE SQLCA statement and a default SQL error routine.
Connected Models
- BIND CONNECTION
- FILL DATASET
- GET CONNECTION
- PREPARE TO FILL
- PREPARE TO UPDATE
- REBIND CONNECTION
- UNBIND DATASET
- UPDATE DATASOURCE
- UNBIND CONNECTION
- TO DELETE USE
- TO FILL USE
- TO INSERT USE
- TO REFRESH USE
- TO UPDATE USE
- Generic SQL Program
Generates a skeleton SQL program that includes the INCLUDE SQLCA, CONNECT and DISCONNECT SQL statements and a default SQL error routine.