Using the DMF parser

Procedure

  1. From the Primary Option Menu, select VSAM/Sequential and press Enter.
  2. From the VSAM/Seq Data Mapping Facility panel, select Map Defaults and press Enter.
  3. Make sure the Parser Version is set of N (New).
  4. Return to the VSAM/Seq Data Mapping Facility Display.
  5. Select Extract VSAM from this menu and press Enter.
  6. Provide the following information:
    • Source Library Name: The data set name and member name that contain the source code for the map you are creating.
    • Start Field: The field name where the map starts building.
    • End Field: The field name where the map stops building. If not specified, the first field that is at the same level as the Start Field stops the build process.
    • Map Name: The name of the map in the DMF. This name also is used as the member name for the map in the mapping data set if possible.
    • Use Offset Zero: If the Start Field is not an '01' level, start the offset at zero; otherwise, the offset starts at the offset of the field in the structure.
    • Flatten Arrays: Determines whether arrays are flattened. Valid values depend on the product:
      • For IBM® z/OS® Platform for Apache Spark SQL, specify C (COMPATIBLE) or Y(YES).
      • For IBM® z/OS® Platform for Apache Spark Streams, specify C (COMPATIBLE) only.
      • For IBM® z/OS® Platform for Apache Spark SQL 92 Engine, specify C (COMPATIBLE), Y(YES), or N (NO).
        Note: The C (COMPATIBLE) value is provided for backwards compatibility with an older mapping architecture. When C is specified, OCCURS fields are flattened in the map and OCCURS DEPENDING ON fields generate an error message.
    • Map Data Set Name: The data set name where the map is stored. The default is the first data set in the SDBMAPP DD statement for the subsystem.
  7. Press Enter. The system displays the VSAM Extract panel.
  8. Provide the following information:
    • For read-only VSAM files allocated to the Data Service server address space: In the VSAM DSN field, type the VSAM data set name (DSN). The DSN is dynamically allocated during the execution of the query.
      Note: To create the sample VSAM file, use the sample hlq.CNTL(DEFSTAFF).
    • For READ/WRITE VSAM files via CICS:
      • The FCT for this VSAM cluster.
      • The CICS connection name, as defined in the Data Service server Initialization EXEC.
      • The mirror transaction name or the transaction ID, as defined in CICS.
      • The name of the Post Read Exit and Pre-Write Exit routines if you are using the exit processing feature.
      • Type Y or N to indicate whether to use alternate indexes for this file. For this example, specify Y (Yes).
  9. Press Enter. If you selected Y for alternate indexes, the VSAM Extract panel appears.
  10. Specify the name of up to eight alternate indexes and press Enter. If the extract completes with no errors, the Extract Successful message appears in the upper right corner of the panel.
  11. Select Map Refresh from the VSAM/Seq Data Mapping Facility menu to refresh the data maps.
Parent topic: Creating data maps for VSAM file access