KNOW YOUR MAINFRAME – WEEK 3

—————————-

1. WHAT COMMAND IS USED TO DELETE ALL LINES FROM A PS/PDS

MEMBER. (NOT LINE COMMANDS)

2. WILL WE GET AN ERROR IN STEP 2 OF THE BELOW JCL. IF YOUR

ANSWER IS YES, WHAT PRECAUTION STEPS CAN BE TAKEN TO AVOID

THE ERROR.

STEP 1. DEFINE VSAM

STEP 2. RUNS A COBOL PROGRAM WHICH OPENS VSAM FILE AS INPUT.

3. WHAT HAPPENS TO THE OPENED DB2 CURSOR (DEFINITION BELOW)

AFTER ISSUING A COMMIT IN THE PROGRAM. WHAT ACTIONS CAN BE

TAKEN TO AVOID THE PROBLEM,IF ANY.

DECLARE ACT_CUR CURSOR FOR

SELECT PA_NO FROM ACCOUNT

Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
KNOW YOUR MAINFRAME
KNOW YOUR MAINFRAME – WEEK 1
KNOW YOUR MAINFRAME – WEEK 1 – SOLUTIONS
KNOW YOUR MAINFRAME – WEEK 2
KNOW YOUR MAINFRAME – WEEK 2 – SOLUTIONS
KNOW YOUR MAINFRAME – WEEK 3
KNOW YOUR MAINFRAME – WEEK 3 – SOLUTIONS
KNOW YOUR MAINFRAME – WEEK 4
KNOW YOUR MAINFRAME – WEEK 4 – SOLUTIONS
KNOW YOUR MAINFRAME – WEEK 5
KNOW YOUR MAINFRAME – WEEK 5 – SOLUTIONS
KNOW YOUR MAINFRAME – WEEK 6
KNOW YOUR MAINFRAME – WEEK 6 – SOLUTIONS


Advertisements