CICS VSAM Transparency for z/OS, Version 1.2


Copybook analysis

Before you convert a VSAM file, you must establish the target DB2® design. One way to do this is to import your copybook into a spreadsheet. Take each field in turn and specify the DB2 column name and data type.

There are a number of common things that you should look for during this process:

  1. Highlight the fields that you want to migrate to DATE, TIME, or TIMESTAMP columns and note how the data is organized with the field. (CCYYMMDD, YYYYDDD for example).
  2. Highlight fields that you know may potentially contain inconsistent field values.
  3. Highlight columns that you want to be nullable.
  4. Identify group fields with OCCURS clauses (arrays in PL/I).
  5. Identify redefined fields.

In many circumstances, you may have a common reengineering requirement across a number of different files. For example, you may have a specific format for date fields that require an exit to convert to DB2 DATE format. You can consider writing a generic exit and using it for multiple fields and files. Sample generic exits are discussed in Generic assembler FBEs .



Concept topic


Last updated: December 6, 2013 20:45:0

Concept Concept

Feedback


Timestamp icon Last updated: Friday, 6 December 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///topics/cvtdeccopybook.html