Editing Method Properties

In this exercise, you will edit the properties of the referential integrity method you just created.
  1. Launch Data Subset Extraction.
  2. In the left pane, expand the Group list, expand the SIMPLESUB list, and then select Methods.
  3. Select the row for the method RIMETHOD, right-click, and then choose Work with selected Method.

    The table information for all data stores has been exported because all data stores are related.

    Notice that the data stores DELGT.CUSTOMER and DELGT.ACCOUNT are elaborated in the step, and that the output class for the DELGT.ACCOUNT data store is the input class for DELGT.CCARD in the subsequent step. Likewise, the output class DELGT.CCARD is the input class for DELGT.OPERAT in the subsequent step.

    Elaborating the data stores in this way preserves referential integrity and shows that the DELGT.CUSTOMER data stores is indirectly related to the DELGT.OPERAT data store.

    The following diagram further demonstrations the data store relations:

    Data Store Model
    Note: The dashed line represents a relationship that exists between data stores because of the combined field.
  4. In the Data Stores Elaboration list, select a row for a DELGT.DataStoreName data store.

  5. Right-click and select Elaboration Properties
  6. In the Unload Output Data Store Properties section, in the Data store name box, type: URADAR.DEMOT.SUB2.DataStoreName. For example, type: URADAR.DEMOT.SUB2.CUSTOMER.
  7. Click OK.
  8. Repeat steps 4-7 for each DELGT.DataStoreName data store.
  9. In the Data Stores Elaboration list of the Work with Method window, select the row for the DELGT.CUSTOMER data store.
  10. Right-click, and then select Elaboration > Selection class / Filter properties.
  11. Choose the filter type FILTER BY LIST VALUE.
  12. In one of the boxes in the lower-left corner, type the following CUSTOMER CODE: 0000000001
    Note: You can verify the customer code in your z/OS DB2 window. However, this customer code is specified in an INSERT statement in the CREATBT.TXT file used to create your DB2 tables.
  13. Click OK to close the Set Filter to Selection Classes window.
    Note: The filter only needs to be specified for the CUSTOMER data store because the BTEDDUR job establishes the relations between all of the other data stores.
  14. Exit Data Subset Extraction by clicking File > Exit.
  15. Continue to the next section.