Database Access Features

Runtimes

We supply several runtimes 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 managed 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 managed 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 managed code.