IVP sample application databases

In the DCCTL environment, the IVP database is simulated through the use of a data area within program DFSIVAD.

Each of four root-only databases in the IVP contains the same six records. The following figure displays the contents (last name, first name, extension number, and zip code) of these records.

Table 1. Contents of IVP root-only database records
Record number Last name First name Ext. number Zip code
1 LAST1 FIRST1 8-111-1111 D01/R01
2 LAST2 FIRST2 8-111-2222 D01/R02
3 LAST3 FIRST3 8-111-3333 D01/R03
4 LAST4 FIRST4 8-111-4444 D02/R04
5 LAST5 FIRST5 8-111-5555 D02/R05
6 LAST6 FIRST6 8-111-6666 D03/R06

DFSIVD1 - HIDAM/OSAM

  • Database description
      Database name:
    IVPDB1
      Segment name:
    A1111111
      Segment length:
    40
      Key field name:
    A1111111
      Key field length:
    10
  • Database Record Format:
    Table 2. Database record format of DFSIVD1
    Offset Length Field name Description
    0 10 A1111111 Last Name
    10 10 N/A First Name
    20 10 N/A Extension Number
    30 7 N/A Internal Zip Code
    37 3 N/A Reserved

DFSIVD2 - HDAM/VSAM

  • Database description
      Database name:
    IVPDB2
      Segment name:
    A1111111
      Segment length:
    40
      Key field name:
    A1111111
      Key field length:
    10
  • Database record format:
    Table 3. Database record format of DFSIVD2
    Offset Length Field name Description
    0 10 A1111111 Last Name
    10 10 N/A First Name
    20 10 N/A Extension Number
    30 7 N/A Internal Zip Code
    37 3 N/A Reserved

DFSIVD3 - DEDB/VSAM

  • Database Description
      Database name:
    IVPDB3
      Segment name:
    A1111111
      Segment length:
    42
      Key field name:
    A1111111
      Key field length:
    10
  • Database record format:
    Table 4. Database record format of DFSIVD3
    Offset Length Field name Description
    0 2 N/A  Segment Length
    2 10 A1111111 Last Name
    12 10 N/A  First Name
    22 10 N/A  Extension Number
    32 7 N/A  Internal Zip Code
    39 3 N/A  Reserved

DFSIVD4 - MSDB

  • Database description
      Database name:
    IVPDB4
      Segment name:
    A1111111
      Segment length:
    40
      Key field name:
    A1111111
      Key field length:
    10
  • Database record format:
    Table 5. Database record format of DFSIVD4
    Offset Length Field name Description
    0 10 A1111111 Last Name
    10 10 N/A  First Name
    20 10 N/A  Extension Number
    30 7 N/A  Internal Zip Code
    37 3 N/A  Reserved

DFSIVD5 - GSAM/BSAM

  • Database description
      Database name:
    IVPDB5
      RECFM:
    F
      RECORD:
    80