Submitting a JCL to Mask Customer First and Last Names

Use the Work with Jobs tool in data builder to submit the JCL that does the actual masking on the CUSTOMER table. Then, submit the job in the mainframe environment and verify your results.
  1. Data Builder, open the Work with Jobs window (click or access it through Environment > Work with Jobs) to schedule a new job.
  2. Click New.
  3. In the List of Jobs, select the job BDCCHGR (Data Store Data Changer).
  4. Select the DATAEXPRES Machine ID and the DEMO company name.
  5. In the Data store type list, click DB2.
  6. Click Apply.

    The job appears in the List of Scheduled Jobs. The pause symbol indicates that the job is awaiting execution. Once the job has completed successfully, the job is listed with a green check mark.

  7. In your TSO environment, submit the BDCCHGR job by using the Submit Client Scheduled Job panel.
  8. In the Work with Jobs area, click the refresh button to verify that the jobs completed successfully.
  9. Click OK or the button to close the Work with Jobs window.
  10. In your mainframe environment, notice that the values in the NAME and SURNAME columns for your input and output datasets are different.
  11. Continue to the next section.
Parent topic: DB2 Data Stores Session