COMPUTER SYSTEM FOR GENERATING SQL STATEMENTS FROM COBOL CODE

摘要

An interfacing computer system which allows a COBOL program, despite its totally different nature and internal data handling constructs and statement approaches, to effectively generate structured Query Language (SQL) statements in accessing and using data from an SQL oriented database (8-9) and getting appropriate data back in a form consistent with what the COBOL program expects. The program's interface module (5) receives COBOL statements from an appropriately compiled COBOL program (3), and, using information contained in a data dictionary (4) created when the COBOL program (1) was compiled (note compiler 2), generates the appropriate SQL statements to access and generate the appropriate data from an SQL oriented database (8-9) for sending back to the COBOL program (3). A number of innovative programming and logic techniques are used, including techniques for enhanced execution speed.