Converting VSAM in COBOL to embedded SQL
Hai Ping Huang, Yamin Wang, Wei‐Tek Tsai · OSTI OAI (U.S. Department of Energy Office of Scientific and Technical Information) · 1996
VSAM databases we 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 databases to relational databases. This paper addresses the issues on converting COBOL programs that access VSAM database to COBOL programs that access relational databases with embedded SQL. It proposed a semi-automatic approach to the conversion of VSAM data sets to SQL tables and VSAM operations in COBOL program to embedded SQL queries. The proposed approach has been experimented on several industrial COBOL programs and a tool implementing the approach is under development.