Database Functionality

Our VSAM Conversion solution provides a complete replacement for all VSAM file functionality, including:

  • VSAM record layouts
  • Group-level elements
  • Redefined data within records
  • Occurring data
  • Multi-View record types
  • Indexes


Post VSAM Conversion - Relational Results


When the VSAM conversion is complete, the resulting database is fully relational. Primary keys, foreign keys, and index definitions are automatically created. All constraints are generated into the resulting DDL. Table spaces, indexes, table names, and column names are all generated according to your naming standards.


Delivered Components


As part of the delivery process, Modern Systems generates and delivers the following component types for installation in the new relational database processing environment by using DB-Shuttle:

  • DDL Syntax for the new database
  • Load Syntax (optional) for use by relational database load utility
  • RI Check Syntax (optional) for use by relational database utility package
  • RUNSTATS Syntax (optional) for use by relational database utility package
  • VSAM Data Extract programs (generated in COBOL and fully self-documented) to unload all VSAM data to the correct format for the relational database load utility
  • VSAM Data Extract JCL (optional; customized to your environment) to execute the extracts and other key-processing utilities
  • DCLGEN syntax (optional) to define COBOL layouts of the tables for replacement applications
Share This