VSAM Conversion for COBOL Programs

Hai Huang, Wei Tek Tsai

Research output: Contribution to journalArticle

Abstract

VSAM database systems are widely used on IBM mainframe systems. COBOL is the most frequently used host language to access VSAM databases. To fix the Year 2000 bug and migrate to new client/server technology, business organizations are re-engineering their legacy COBOL programs and converting VSAM databases to SQL databases. This paper addresses two important problems in VSAM conversion: database schema conversion and SQL query generation. 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 have been tested on COBOL programs from industry.

Original languageEnglish (US)
Pages (from-to)311-337
Number of pages27
JournalJournal of Software Maintenance and Evolution
Volume11
Issue number5
StatePublished - Sep 1999
Externally publishedYes

Fingerprint

Industry
Servers

Keywords

  • Code migration
  • Code restructuring
  • Database access methods
  • Query generation
  • Schema conversion
  • SQL

ASJC Scopus subject areas

  • Computer Graphics and Computer-Aided Design
  • Software
  • Computer Science(all)

Cite this

Huang, H., & Tsai, W. T. (1999). VSAM Conversion for COBOL Programs. Journal of Software Maintenance and Evolution, 11(5), 311-337.

VSAM Conversion for COBOL Programs. / Huang, Hai; Tsai, Wei Tek.

In: Journal of Software Maintenance and Evolution, Vol. 11, No. 5, 09.1999, p. 311-337.

Research output: Contribution to journalArticle

Huang, H & Tsai, WT 1999, 'VSAM Conversion for COBOL Programs', Journal of Software Maintenance and Evolution, vol. 11, no. 5, pp. 311-337.
Huang, Hai ; Tsai, Wei Tek. / VSAM Conversion for COBOL Programs. In: Journal of Software Maintenance and Evolution. 1999 ; Vol. 11, No. 5. pp. 311-337.
@article{ee12fe6df7c94d18b1dae5929a3aa1b2,
title = "VSAM Conversion for COBOL Programs",
abstract = "VSAM database systems are widely used on IBM mainframe systems. COBOL is the most frequently used host language to access VSAM databases. To fix the Year 2000 bug and migrate to new client/server technology, business organizations are re-engineering their legacy COBOL programs and converting VSAM databases to SQL databases. This paper addresses two important problems in VSAM conversion: database schema conversion and SQL query generation. 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 have been tested on COBOL programs from industry.",
keywords = "Code migration, Code restructuring, Database access methods, Query generation, Schema conversion, SQL",
author = "Hai Huang and Tsai, {Wei Tek}",
year = "1999",
month = "9",
language = "English (US)",
volume = "11",
pages = "311--337",
journal = "Journal of software: Evolution and Process",
issn = "2047-7481",
publisher = "John Wiley and Sons Ltd",
number = "5",

}

TY - JOUR

T1 - VSAM Conversion for COBOL Programs

AU - Huang, Hai

AU - Tsai, Wei Tek

PY - 1999/9

Y1 - 1999/9

N2 - VSAM database systems are widely used on IBM mainframe systems. COBOL is the most frequently used host language to access VSAM databases. To fix the Year 2000 bug and migrate to new client/server technology, business organizations are re-engineering their legacy COBOL programs and converting VSAM databases to SQL databases. This paper addresses two important problems in VSAM conversion: database schema conversion and SQL query generation. 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 have been tested on COBOL programs from industry.

AB - VSAM database systems are widely used on IBM mainframe systems. COBOL is the most frequently used host language to access VSAM databases. To fix the Year 2000 bug and migrate to new client/server technology, business organizations are re-engineering their legacy COBOL programs and converting VSAM databases to SQL databases. This paper addresses two important problems in VSAM conversion: database schema conversion and SQL query generation. 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 have been tested on COBOL programs from industry.

KW - Code migration

KW - Code restructuring

KW - Database access methods

KW - Query generation

KW - Schema conversion

KW - SQL

UR - http://www.scopus.com/inward/record.url?scp=0347240672&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0347240672&partnerID=8YFLogxK

M3 - Article

VL - 11

SP - 311

EP - 337

JO - Journal of software: Evolution and Process

JF - Journal of software: Evolution and Process

SN - 2047-7481

IS - 5

ER -