Geneva

Exercise #1

a) Submit GENEVA.GV4..JCL(GV4T1SEL), where is your Training ID.

b) Review the report that appears in (E)JES in job 5FMT and file PRINTER1.

c) Review the following control reports:

JOB DDNAME STEPNAME

5FMT MR88RPT PSTEP205

4EXT MR95RPT PSTEP705

3REF MR71RPT PSTEP715

1SEL MR86RPT PSTEP105

Exercise #2

a) Do a “Save As” on the view used in Exercise #1 (View 2690). Change the View Name to “Exercise #2”.

b) Change the View Folder to your User ID.

c) Change the output logical and physical files to FMTOUT01.

d) Insert a new column after column 5 and set it equal to a Constant of 1. Set the Column Properties as follows:

1) Data Type: Packed

2) Length: 7

3) Decimal Count: 0

4) Subtotal Code: Sum

e) Compile the view and save it.

f) Add this new view to @VIEWLST and run GV4T1SEL.

g) Run the GV4T9F01 job for FMTOUT01 and look for a return code of 0.

Exercise #3

a) Do a “Save As” on the view used in Exercise 2. Change the View Name to “Exercise #3”.

b) Change the output logical and physical files to FMTOUT02.

c) Change the Corresponding File to point to the last three years worth of data from Colorado.

d) Select only records from the month of March.

e) Insert three new columns after the rightmost column. Use a formula on each column to select only the transactions for the appropriate year (“2003”, “2004”, and “2005”) for the Total Amount. Set the Column Properties as follows:

1) Data Type: Packed

2) Length: 7

3) Decimal Count: 2

4) Report Mask: No Mask

5) Subtotal Code: Sum

f) Add this new view to @VIEWLST and run GV4T1SEL.

g) Run the GV4T9F02 job for FMTOUT02 and look for a return code of 0.

Exercise #4

a) Do a “Save As” on the view used in...