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