Convert/IDMS-DB is a fully automated Migration solution that converts your existing IDMS/DB programs, data and databases into ready-to-test applications supporting any ANSI standard SQL environments including DB2, Oracle, Informix or Sybase. The converted applications are functionally identical to their IDMS
counterparts. IDMS Migration reduces the time, cost and risk associated with other conversion alternatives and results in consistent, error-free, standardized code.

Convert/IDMS-DB Output
All IDMS/DB components are  converted to equivalent relational database  components:

• IDMS/DB programs are converted from DML to ANSI standard SQL
• The IDMS schema is converted to DDL for the target environment (ANSI standard SQL including DB2, Oracle, Informix or Sybase)
• A set of programs is generated to convert your data from the current IDMS environment to the target relational environment

Customization Options
Our Convert/IDMS-DB product provides for a variety  of user program customization options including:

• Renaming of programs, copybooks and other components
• Whether COBOL SELECT statements are to be generated as SELECT * or as SELECT fieldname
• Whether COBOL PERFORM statements are to be generated as a PERFORM sectionname or as a PERFORM paragraphname THRU paragraphname-EXIT
• The type of library control cards to be used for COBOL programs and copy members (e.g. IEBUPDTE, CA-Librarian, CA-Panvalet, etc.)
• Whether existing IDMS statements should be removed from the converted program or left in the program and converted to comments
• Convert/IDMS-DB also provides a number of standard schema customization options including:
  Whether data access should be via a TABLE or VIEW
• Whether SQL host variables should be generated as 01 LEVELs or 05 LEVELs
• Whether SQL host variable prefixes should be generated
• What format should be used for DATE and TIME fields (ISO, US, European or Japanese)
• What structural changes should be made to the relational databases (such as group and elementary item selection, date and time field designations, primary and foreign key modification)
• Renaming of all tables, views and columns