Product characteristics
ESQL-COBOL (BS2000/OSD) V3.0 implements the “embedded SQL” application program interface to the SESAM/SQL Server V5.0 database management system for COBOL applications in BS2000/OSD.
ESQL-COBOL (BS2000/OSD) V3.0 allows unrestricted use of the extended SQL functionality of SESAM/SQL Server V5.0
ESQL-COBOL (BS2000/OSD) V3.0 is required purely as an SQL precompiler for program development. The SQL runtime system is a component of SESAM/SQL Server.
The SQL runtime system is always required in order to use ESQL-COBOL (BS2000/OSD) V3.0. SESAM/SQL Server V5.0 is consequently required to precompile embedded SQL-COBOL programs even if precompilation takes place with no check against the database schemata.
Scope of SQL functions
searches for data records (SELECT statement) including higher functions such as join, arithmetic, aggregate functions (e.g. averaging)
adding, modifying, deleting records.
SESAM/SQL enables data to be manipulated and functions for administering databases to be executed (see the SESAM/SQL-Server (BS2000/OSD) manual [17].
Technical notes
The SQL statements of an ESQL-COBOL program are embedded in the COBOL code and are replaced with COBOL source code by a precompiler. The output from the precompiler is regular COBOL source code that has to be compiled with the COBOL2000 compiler. In addition, the precompiler extracts the SQL statements and transforms them into “SQL objects”.
The compiled COBOL program is linked with the SQL objects, the COBOL and DBMS runtime modules, and with a runtime system for the SQL objects; the result is an executable program.