ESAI - Enterprise Systems Associates, Inc.

Back to Applications & DB2 Solutions Products

Enterprise Systems Associates, Inc.

ESAI ProductsESAI ServicesESAI TrialsAbout ESAIContact ESAIESAI Home Page

Convert/VSAM

Convert/VSAMConvert/VSAM is a fully automated Migration service solution that converts your existing VSAM programs, data and files 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 VSAM counterparts. VSAM Migration reduces the time, cost and risk associated with other conversion alternatives and results in consistent, error-free, standardized code.

Convert/VSAM Output
All VSAM components are converted  to equivalent relational database components:

  • VSAM programs are converted to ANSI standard SQL programs
  • The VSAM file definitions are 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 VSAM environment to the target relational environment

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

  • Renaming of programs, copybooks and other components
  • Whether COBOL SELECT statement 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 VSAM statements should be removed from the converted program or left in the program and converted to comments

Convert/VSAM also provides a Click to trial this product 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 mad 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
ŠEnterprise Systems Associates, Inc.
All trademarks are of their respective trademark holders.
.