Converting VSAM in COBOL to Embedded SQL

Date of Submission: 
January 1, 1998
Report Number: 
VSAM database systems are widely used on IBM mainframe systems. As new technology, such as relational database and client-server computing, becomes popular, there is a need to reengineer the VSAM to relational databases. This paper addresses the issues involved in converting COBOL programs that access VSAM database to the ones that access relational databases using embedded SQL. It proposes a semi-automatic approach to the conversion of VSAM data sets to SQL tables and the conversion of VSAM operations to embedded SQL statements. The proposed approach and a prototype tool has been tried on industrial COVOL programs.