Hi,
Please help me in writing a job.
My requirement is:
Below 5 jobs are creating 5 output files. We have to build a job to merge these files and create a report where jobs are completed successfully. We have to check each job seperately
Please populate the Report with trailer records information from the below Input files.
If job ran successfully, the JCL/program should scan the input files for tralier records, extract account number, total number of checks and total amount and write to the report.
If a job did not run on a day, the report should show an Error like..."XXXXX" with zeros on all accounts.
If a job ran successfully and there was no information on the file for a particular account, the report should show zeros against that account.
I am not sure if these can be done in the job or we should write a cobol module. Please let me know if we should discuss further.
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
Offhand, it sounds doable with a utility or reporting tool (DFSORT, SAS, Easytrieve).
If you want to try it with DFSORT, providing you have DFSORT installed, I would recommend that you gather up all the details (dataset record formats and record lengths), the format of the STATUS file, what the input records look like, what you want the output to look like, and post it all here.
Total Record Layout for Inputs other than XXX012CM
Columns Fields Name Formats
01 - 14 Account Number Right justified, Left zero filled
16 - 24 Check Serial Number All 9's
25 - 32 Number of Checks Right justified, Left zero filled
33 - 44 Total Amount Right justified, Left zero filled
45 - 80 Filler Spaces
Total Record Layout for XXX015CM
Columns Fields Name Formats
01 - 15 Account Number Right justified, Left zero filled
16 - 24 Check Serial Number All 9's
25 - 32 Number of Checks Right justified, Left zero filled
33 - 44 Total Amount Right justified, Left zero filled
45 - 80 Filler Zeros
Report should look like
Date : MM/DD/YY PAID RECEIVED REPORT
BANK OF AMERICA EAST
ACCOUNT NUMBER TOAL NUMBER OF CHEKCS TOTAL AMOUNT
8765360037
8765460145
8765800960
***Error Line(optional)
BANK OF AMERICA WEST
ACCOUNT NUMBER TOAL NUMBER OF CHEKCS TOTAL AMOUNT
0000051311
***Error Line(optional)
MELLON
ACCOUNT NUMBER TOAL NUMBER OF CHEKCS TOTAL AMOUNT
0000106224
***Error Line(optional)
WELLS FARGO
ACCOUNT NUMBER TOAL NUMBER OF CHEKCS TOTAL AMOUNT
9600192765
5900070235
5900048405
0000030015
0000054850
0000753141
0000776124
0000022381
0000022568
7824560457
***Error Line(optional)
CHASE
ACCOUNT NUMBER TOAL NUMBER OF CHEKCS TOTAL AMOUNT
0601226418
superk wrote:
Offhand, it sounds doable with a utility or reporting tool (DFSORT, SAS, Easytrieve).
If you want to try it with DFSORT, providing you have DFSORT installed, I would recommend that you gather up all the details (dataset record formats and record lengths), the format of the STATUS file, what the input records look like, what you want the output to look like, and post it all here.