VSAM转换为COBOL程序

J. Softw. Maintenance Res. Pract. Pub Date : 1999-09-01 DOI:10.1002/(SICI)1096-908X(199909/10)11:5%3C311::AID-SMR197%3E3.0.CO;2-4

H. Huang, W. Tsai

{"title":"VSAM转换为COBOL程序","authors":"H. Huang, W. Tsai","doi":"10.1002/(SICI)1096-908X(199909/10)11:5%3C311::AID-SMR197%3E3.0.CO;2-4","DOIUrl":null,"url":null,"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. Copyright © 1999 John Wiley & Sons, Ltd.","PeriodicalId":383619,"journal":{"name":"J. Softw. Maintenance Res. Pract.","volume":"36 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1999-09-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"VSAM conversion for COBOL programs\",\"authors\":\"H. Huang, W. Tsai\",\"doi\":\"10.1002/(SICI)1096-908X(199909/10)11:5%3C311::AID-SMR197%3E3.0.CO;2-4\",\"DOIUrl\":null,\"url\":null,\"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. Copyright © 1999 John Wiley & Sons, Ltd.\",\"PeriodicalId\":383619,\"journal\":{\"name\":\"J. Softw. Maintenance Res. Pract.\",\"volume\":\"36 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1999-09-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"J. Softw. Maintenance Res. Pract.\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1002/(SICI)1096-908X(199909/10)11:5%3C311::AID-SMR197%3E3.0.CO;2-4\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"J. Softw. Maintenance Res. Pract.","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1002/(SICI)1096-908X(199909/10)11:5%3C311::AID-SMR197%3E3.0.CO;2-4","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

摘要

VSAM数据库系统广泛应用于IBM大型机系统。COBOL是访问VSAM数据库最常用的主机语言。为了修复2000年错误并迁移到新的客户机/服务器技术，业务组织正在重新设计其遗留COBOL程序并将VSAM数据库转换为SQL数据库。本文讨论了VSAM转换中的两个重要问题:数据库模式转换和SQL查询生成。它提出了一种将VSAM数据集转换为SQL表和将VSAM操作转换为嵌入式SQL语句的半自动方法。所提出的方法和原型工具已经在工业上的COBOL程序上进行了测试。版权所有©1999 John Wiley & Sons, Ltd

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

VSAM conversion for COBOL programs

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. Copyright © 1999 John Wiley & Sons, Ltd.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

J. Softw. Maintenance Res. Pract.

自引率

0.00%

发文量