how to create a changeman read only audit and update only audit Specifications for the Read only Audit 1) Read HFFD database unqualified. 2) Read FDRT, FDDM, FDAP segments. If FDAP-APP-STS is ‘2’ read the FDAV segment and get the FDAV segment which has FDAV-APV-OPTION as ‘X’ If FDAP-APP-STS is ‘5’ read the HFAC database. Read the ACRT segment qualified based on the key obtained from the FDAP segment from HFFD database. Conditions for writing into output file: a. App Type should be NEWR b. App Status should be 1, 2 & 5. c. Write 50 records per app status. For e.g. first 50 records for App status 1, 2 & 5 each The output file should contain the following fields from the database FDRT-COMP-CTRY-CODE X(03). FDRT-CUST-ID-NUM X(10) FDDM-DEM-SEQ-NUM X(01) FDAP-APP-SEQ X(02) FDAP-JNT-IND X(01) FDAP-APP-STS X(01) FDAV-APV-OPTION X(01) FDAV-APV-DT X(06) FDAV-APV-AMT X(07) ACRT-ACCT-NUM X(06) ACRT-SEG-BUS-TYPE X(02) ACRT-NM1-LAST X(19) ACRT-NM1-SS X(09) ACRT-NM1-1ST X(12) ACRT-NM1-INIT X(01) ACRT-NM1-SFX X(03) ACRT-NM1-TITLE X(02) PSB – DVAN2BMP In case you get a GE for any of the conditions, write to output file along with the details of the database segment which was not found. We need to complete this whole process by tomorrow. Run the audit in DLI mode. 2) Sort the output file created in step 1 on Cust ID, Dem Seq & App Seq. Specifications for the Update Audit 3) Take the output of step 2 as input for an update audit. Details are as follows: Read each record & check the app status. If app status is less than 2 then update the FDAP-NEW- MONEY-ENT to $25000.00 PSB - AUDBMPJ The job would be a BMP job. The test job would be run in IMSE region. Note - The proc (which will be called by the job) and the job should also be present in the change-man package itself. You’ll have a test job in your PDS along with overrides to execute the program in test regions. The job would be a DLI job. The test job would be run in IMSE region. It’ll have the following steps. 1) Delete-define output and error files. 2) Use a copybook for the output layout.2435
My IMS main progam is calling Db2 subroutine ...Its giving - 923 db2 sql code..so could any one tell how to solve this issue.2377
Desirability of TCP/IP STANDARDS
what is difference between user exit, customer exit and badi?
Can i use the B-curve MCB instead of C-curve MCB
WHAT IS THE CRITERIA FOR SELECTION OF TIME OF DISSOLUTION AND THE MEDIUM OF DISSOLUTION?
SBI conducted the exam in 6 shifts. some papers are easy and some are difficult. will the merit list be prepared for all papers equally or distinctly. please reply
what difference between args.length and args.length() in command line argument?
what is impurity profile. how to interpret this impurity profile to a drug product or drug substance.
10.Define filters,binary to hexadecimal,hexadecimal to decimal?
when will be the iocl interview results i faced interview on 8th september 2008 iam from electrical branch i faced interview for the post of electrical engineer??????????????????????//
what are essential components of digital computer? discuss the function of each components. draw the block diagram of a computer showing its essential components
How do you control cylinder liner wear?
What is Map,List,hashtable,ArrayList and difference between them??
How do we calculate the cost of investment?
What is the meaning of Brick- M 35 grade? Is it a common brick or it's a concrete brick?
DESCRIBE WHY MANAGEMANT EDUCATION YOU WANT TO PURSUE???????/