Submitting a JCL to Subset Customer Names

Use the Work with Jobs tool in Data Builder to submit the JCL that does the actual subsetting on the CUSTOMER table. Then, submit the job in the mainframe environment and verify your results.
  1. In Data Builder, open the Work with Jobs window (Environment > Work with Jobs) to schedule a new job.
  2. Click New.
  3. In the List of Jobs, select the job BTESBMR (test environment creation).
  4. Select the DATAEXPRES Machine ID and the DEMO company name.
  5. In the Data store name box, type: *CUSTOMER*.
  6. Click Apply.
  7. In the Group list, click SIMPLESUB.
  8. In the Method list, click SIMPLE.
  9. Click OK. 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.
  10. In your TSO environment, submit the BTESBMR job by using the Submit Client Scheduled Job panel.
  11. In the Work with Jobs area, click the Refresh button to verify that the jobs completed successfully.
  12. Click OK or the button to close the Work with Jobs window.
  13. In your mainframe environment, notice that only information for the value Rick in the NAME column for your output dataset is listed.
    Note: Because the Name class is associated to a masking routine, the data was masked as well as reduced.
  14. If you are planning to go straight on to the next tutorial to complete subsetting on sequential data, you can keep Data Builder open. Otherwise, either click File > Exit and then click Yes.
Parent topic: DB2 Data Stores Session
Parent topic: Sequential Files Session