Database Access Features

Run-times
We supply several run-time systems to communicate with your running SQL applications, including:
  • OpenESQL ODBC Runtime - communicates with native COBOL SQL applications that use any type of database.
  • OpenESQL .NET Managed Runtime - communicates with .NET COBOL SQL applications that use any type of database
Preprocessors
Our database access preprocessors enable you to access relational databases by embedding SQL statements within your COBOL programs. The programming details differ with each preprocessor, resulting in many programming options. They also offer a wide range of features to assist you in the programming process.
  • OpenESQL for use with ODBC 3.0-compliant drivers and CLR2 and CLR 4 ADO.NET data providers
  • DB2 ECM for use with DB2 databases
  • COBSQL for use with COBOL preprocessors supplied by relational database vendors
    Note: You can also use a preprocessor supplied by your database vendor without COBSQL.
Stored Procedures
We support COBOL stored procedures for DB2 LUW and SQL Server 2008 or later.
We support SQL CLR stored procedures for SQL Server 2008 R2 and later
Note: We do not provide details about SQL syntax, error messages returned or any use of SQL outside of the COBOL environment. For details of these, refer to the documentation supplied by your database vendor. For .NET COBOL code under .NET, ignore all references to COBSQL, and DB2 that appear in the remaining topics in this Database Access documentation. They do not apply to .NET COBOL code.