Using Embedded EXEC ADO Statements

OpenESQL provides extended support for ADO.NET data providers with EXEC ADO statements. You can embed these 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

• Disconnected Model Statements
  
• Connected Model Statements
  
• ADO.NET Cursor Statements
  
• Sharing ADO.NET Objects Statements