Number Hunt
Part Two - Challenge #15

Background:

Challenge requires the sum of 8 numbers. You must find the 8 numbers to sum.

A correct number is required to complete the challenge.

The correct number is the sum of 8 numbers from 4 separate data sources.
The 4 data sources include:

  1. Sequential Data Set Name
  2. Partitioned Data Set Member Name
  3. Unix File Name
  4. DB2 Table

Each number may be in 1 of 3 formats:

  1. EBCDIC
  2. ASCII
  3. Packed Decimal

Each non-EBCDIC number must be converted to an EBCDIC numeric value where the sum of the EBCDIC numeric values is the single number required to complete the challenge.

You will be given the name of the data sources, specific record numbers, beginning and ending column numbers within the specific record to find the number. You will NOT be given the data format such as EBCDIC, ASCII, or Packed Decimal. You will need to view the hexadecimal representation to determine when value is either ASCII or Packed Decimal.


Summary Information About the Challenge

You are prepared to complete the challenge based upon what you learned in previous Part 2 challenges.

What you learned in previous Part 2 challenge:

  • Edit, View, or Browse sequential data set names
  • Edit, View, or Browse partitioned data set member names
  • Edit, View, or Browse unix file names
      Use Data Set List Utility panel (3.4), then enter /z/z##### ....substituting your ID for z#####
      Enter 'e', 'v', or 'b' to the left of any file to edit, view, or browse the data
  • Use ISPF primary and line commands to
      - display column ruler
      - display hexadecimal values
      - move forward, backward, right, and left in data set
  • Interpret a packed decimal format
      - packed decimal number can be positive or negative
      - a negative packed decimal number requires a subtraction operation when summing the numbers
  • Use DB2 for z/OS SQL interactively to 'select' data from a DB2 table

Challenge:

Data Sources with respective Record Numbers, Column Numbers, and DB2 Table Column Names containing the 8 numbers to be summed

Character Encoding Table is available to help complete the challenge.

Enter the command below from ISPF command line to create the challenge data sources.

tso submit 'zos.public.jcl(p2final)'

REMINDER: Substitute your ID for Z#####

Sum the 8 numbers found in the specified record and column positions from the following data sources:

  • Data Set Name Z#####.HUNT1
      #1 Record 14 Column 35 to 38
      #2 Record 18 Column 78 to 80
  • Data Set Name Z#####.HUNT2 Member Name FRED
      #3 Record 7 Column 1 to 3
      #4 Record 9 Column 47 to 49
  • Unix File Name /z/z#####/dennis
      #5 Record 6 Column 42 to 45
      #6 Record 11 Column 31 to 33
  • DB2 Table IBMUSER.EMP
      #7 Column PHONENO where lastname is YAMAMOTO
      #8 Column BONUS where lastname is YAMAMOTO

Actions to complete challenge successfully

Take the following steps to record your answer for scoring:

  1. Edit Z#####.JCL member name P2DONE
  2. Modify 0000 value located on the last line to the sum of the 8 numbers
  3. Submit JCL with the modified value

Successful complete of P2DONE writes answer to P2.OUTPUT(#15) and deletes data sources


You demonstrated the ability to locate and convert specified data fields from a variety of data formats within a variety z/OS data sources in the final challenge of Part 2.

Congratulations! You just completed Part 2. Time to check your work.

Next: Completing Part 2