Book issue and return tracking system is a database application. The main aim of this paper is to do all kind of transactions and to store the information of books and students and to retrieve all information and students should make use of all the books present in the library thereby various department students should get satisfaction. Here the code is generated making use of OpenESQL using Micro Focus Net Express 5.1 embedded in COBOL The Open ESQL is an interactive tool that makes it easy to Prototype SQL SELECT statements and test them against database Design SQL INSERT, UPDATE, and DELETE statements It inserts SQL queries into COBOL code and creates auxiliary code into COBOL code.