Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

If job ran successfully, the JCL should scan the input file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
srini_gunja
Currently Banned

New User


Joined: 24 Aug 2005
Posts: 7

PostPosted: Mon May 15, 2006 3:01 pm    Post subject: If job ran successfully, the JCL should scan the input file
Reply with quote

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.

XX012BA - xxxx01.xxxx.xxx
XX012ML - xxxx02.xxxx.xxx
XX012SH - xxxx03.xxxx.xxx
XX0120 - xxxx04.xxxx.xxx
XX015CM - xxxx05.xxxx.xxx

The report should look like as below.


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.
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Mon May 15, 2006 3:19 pm    Post subject: Re: BUILDING OF NEW JOB
Reply with quote

How do you determine if a job ran successfully, or if a job did not run on a day?
Back to top
View user's profile Send private message
srini_gunja
Currently Banned

New User


Joined: 24 Aug 2005
Posts: 7

PostPosted: Mon May 15, 2006 3:28 pm    Post subject: Re: BUILDING OF NEW JOB
Reply with quote

We will check in a STATUS file.......
superk wrote:
How do you determine if a job ran successfully, or if a job did not run on a day?
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Mon May 15, 2006 3:56 pm    Post subject: Re: BUILDING OF NEW JOB
Reply with quote

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.
Back to top
View user's profile Send private message
srini_gunja
Currently Banned

New User


Joined: 24 Aug 2005
Posts: 7

PostPosted: Mon May 15, 2006 4:20 pm    Post subject: Re: BUILDING OF NEW JOB
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us