Convert/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 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
|