Transcript ISU ITK MVS system: Getting Started with SPUFI John Muir Itk494

ISU ITK MVS system:
Getting Started with SPUFI
John Muir
Itk494
2006-08-08
To use SPUFI (SQL Processing Using File Input), start a 3270 emulator
session and log on to the QA LPAR. Type 3.2 <enter>
Type ‘STUREAD.ITK.SPUFI’ <enter>
Press <F3>
Type A and ‘@378102.ITK.SPUFI’ where
@378102 is your userID.
Press <enter>
You should see ‘Data set allocated’ in the
top right corner.
End <F3> out of 3.2 and you should be back
at the ISPF Primary Option Menu
Type M <enter>
Type 12 <enter>
Type 1 <enter>
Type ITK.SPUFI(STUTS) and RESULTS
<enter>
Type CS, 3390, 10, and 25 <enter>
Press <enter>, then type COPY
Type ‘STUREAD.ITK.SPUFI(STUTS)’ <enter>
Type REC ON <enter>
Type C @378101 @378102 ALL where
@378102 is your userID <enter>
Check that your userID now appears in the
text.
Then press <F3>.
Press <enter> to execute the SQL.
Note that your results are in a data set called
@378102.RESULTS where @378102 is your
userID. Then <F3> to exit.
After you use SPUFI for the first time, your defaults will be saved. So
type NO in the CHANGE DEFAULTS field so that you won’t see the
CHANGE DEFAULTS panel after every SQL execution.
You can now edit, then execute
more SQL, or press <F3> three
times to get back to the ISPF
Primary Option Menu.