how to get minimun, maximun records grouped?

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

Moderators: Frank Yaeger, Moderator Group

Post Reply
Titinao
Member
Posts: 5
Joined: Fri Oct 01, 2010 7:53 pm

how to get minimun, maximun records grouped?

Post by Titinao » Fri Oct 01, 2010 10:17 pm

Hi, I really appreciate your help on this.

I have an input file like:

ACCOUNT DATE TX_NBR OPEN_BALANCE CLOS_BALANCE
1 2010-01-01 2 10 40
1 2010-01-01 3 11 41
1 2010-01-01 1 12 42
1 2010-01-02 2 13 43
1 2010-01-02 1 14 44
2 2010-01-01 3 40 80
2 2010-01-01 1 41 81
2 2010-01-01 2 42 82

and I need to get a file having the records sorted by account and date and to print for each ACCOUNT/DATE just the OPEN_BALANCE of the record having the lowest TX_NBR and the CLOS_BALANCE of the record having the highest TX_NBR.

ACCOUNT DATE OPEN_BALANCE CLOS_BALANCE
1 2010-01-01 12 41
1 2010-01-02 14 43
2 2010-01-01 41 80

Is possible to do this using just one sort step?

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Fri Oct 01, 2010 10:42 pm

What is the RECFM and LRECL of the input file?

What is the starting position, length and format of each field?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Titinao
Member
Posts: 5
Joined: Fri Oct 01, 2010 7:53 pm

Post by Titinao » Fri Oct 01, 2010 11:47 pm

Frank Yaeger wrote:What is the RECFM and LRECL of the input file?

What is the starting position, length and format of each field?
Frank:

Starting position: 1

Input file structure:
01 ACC-HISTORY.
10 ACCT-NBR PIC S9(11)V USAGE COMP-3.
10 TXN-DATE PIC X(10).
10 TXT-NBR PIC S9(9) USAGE COMP.
10 OPEN-BAL PIC S9(18)V USAGE COMP-3.
10 CLOS-BAL PIC S9(18)V USAGE COMP-3.

Thank you

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