Creating a data map from SQL

Edit online

Data Virtualization Manager server allows you to create a data map using SQL functions.

Procedure

  1. From the Data Virtualization Manager server - Primary Option Menu, select IMS and press Enter.
  2. From the Server IMS Control Facility menu, select IMS Data Mapping and press Enter.
  3. Select Generate a View of an IMS/ DB DBD and Segment from the menu and press Enter.
  4. 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 this name is not specified, the first field that is at the same level as the Start Field stops the build process.
    • Case Sensitive: If the Start Field or End Field are case-sensitive, set this value to Y (Yes) to preserve the case.
    • 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.
    • Convert Var to True: Set this value to Y (Yes) to convert VAR fields to TRUE VAR fields. TRUE VAR fields have a 2-byte data length field preceding the data.
    • Flatten Arrays: Determines how arrays are processed. Valid values depend on the data source:

      • Flatten arrays into a single fixed table at runtime (Y)

      • Return arrays into separate tables at runtime (N)

      • Flatten arrays now (C)

    • Map Data Set Name: The data set name where the map is stored. The default is the first data set in the AVZMAPP DD statement for the subsystem in the server started task.
    • DBD Name: The name of the DBD for which you are creating a view.
    • Segment Name: The name of the Segment, from the specified DBD, for which you are creating a view.
    • PSB Name: The name of the PSB to use to access the specified segment.
      Note: If you leave this field BLANK, the product automatically selects a PSB name based on the SQL query.
    • PCB Name: The name of the PCB, from the specified PSB, to use to access the specified segment.
      Note: If you leave this field BLANK, the product automatically selects a PCB name based on the SQL query.

    Press Enter.

  5. If either the DBD Name or Segment Name field is BLANK, the system displays a panel allowing you to choose a name from a selection list. Select a DBD Name or Segment Name from the Selection List.
  6. Press Enter. If the operation is successful, the Create Successful message appears on the panel.