Data Conversion

The IDMS data extract and relational load process is simple and straightforward. During the extract process, all IDMS traversal is based upon mandatory/optional set relationships and the clustering specifications defined within the IDMS schema. The IDMS data extracts are fast and can be executed simultaneously. We can provide a number of extract variations for sites that have special requirements for a short IDMS conversion window.

Re-Engineering and Customization Workbenches

Special workbenches within DB-Shuttle® provide additional capabilities for tailoring your IDMS migration so that it better meets your requirements:

  • Rename Workbenches to allow full naming of all tables, columns, table spaces and indexes using a rules basis or a full-name basis
  • Data Cleansing Workbench to provide rule-based data cleansing during the IDMS data extract process
  • Date Conversion Workbench to allow the specification of the format of IDMS date fields along with the individual IDMS date field minimum and maximum values so that the DATE column specification can be used in relational databases (all date formats are supported)
  • Element Rename Workbench which allows selection of group level or elementary IDMS fields for use as columns in the relational database
  • Record Re-Definition Workbench to allow changes to field types and lengths during the relational conversion
  • Set Re-Definition Workbench to allow changes in the set definitions during the IDMS conversion
  • Co-Existence Record Conversion Workbench for sites who choose to convert and implement their large IDMS databases using a phased approach, specifying groups of IDMS record types for each conversion phase

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:

  • Data Definition Language (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
  • IDMS Data Extract programs (generated in COBOL and fully self-documented) to unload all IDMS data to the correct format for relational database load utility
  • IDMS 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

Heads up! This website is no longer being updated as of 2022. For the most up-to-date information on Advanced's modernization services and/or for any enquiries, go to