USING SORT SUMTOTAL FIELDS AND TALLY TO FILE TRAILER COUNT

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
deboxtreme
Member
Posts: 1
Joined: Tue Jun 16, 2015 1:58 am

USING SORT SUMTOTAL FIELDS AND TALLY TO FILE TRAILER COUNT

Post by deboxtreme » Tue Jun 16, 2015 2:13 am

Hi ,

I have a query on how to achieve the below through SORT -

1. SUM OF VALUES FOR RECORDS (IN A FILE) WHERE POS 10='A'.
2. COMPARE THE ABOVE TOTAL VALUE TO THE FILE TRAILER COUNT.

EG: THE FILE HAS (SAY) 5 RECORDS AS BELOW
A11VDPL 001
W11DSAL 123
A21MJDK 067
W21DFLI 111
ZTRAIL 002

NOW FOR ONLY (1,1,CH,EQ,C'A') THE TOTAL OF VALUE SHOULD HAPPEN OF (3,1,ZD) AND THAT SHOULD MATCH WITH (1,1,CH,EQ,C'Z') VALUE THAT'S 002.

OUTPUT CAN BE A FILE WHICH CAN HAVE 01 FOR MATCH AND 00 NON-MATCH.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others