Using Embedded EXEC ADO Statements

To enhance ADO.NET support, a new family of EXEC ADO statements has been added to OpenESQL. These statements operate with DataSets rather than databases but their syntax is familiar to anyone with a knowledge of SQL and embedded SQL. Other EXEC ADO statements have been added which allow direct access to the underlying ADO.NET objects used by the OpenESQL Managed Runtime. With these statements it is possible for OpenESQL to share connections and transactions with other software components or for COBOL programmers to use low level properties and methods of objects that have been created by OpenESQL.

You embed EXEC ADO statements into a COBOL program in the same way as EXEC SQL statements. Embedded EXEC ADO statements enable you to:

• Program ADO.NET calls without writing COBOL calls to the native ADO.NET API
• Define, create and manipulate DataSets and associated objects in the ADO.NET disconnected model
• Manipulate the underlying data source in the ADO.NET connected model, retrieving data as well as updating it
• Declare and manipulate an ADO.NET DataRows cursor in the same way as a SQL cursor
• Save and load ADO.NET DataSets (schema and data) to and from XML files
• Share ADO.NET objects between COBOL programs and other .NET applications
• Share calls and information between EXEC ADO and EXEC SQL statements in the same program