Generate Report of Product Information

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

Moderators: Frank Yaeger, Moderator Group

Post Reply
racermark5
Member
Posts: 1
Joined: Fri Mar 02, 2018 5:51 pm

Generate Report of Product Information

Post by racermark5 » Mon Mar 05, 2018 11:18 am

I have a file containing product information in the following manner:
Branch_Code - Product_ID - Quantity - Price
9(3) X(10) 9(3) 9(6)
I need to create a report of the products sorted and grouped by branch codes i.e. add headers describing the column fields, and a line after every group of branch codes with the total Qty & Price of products of that particular branch code. There could be any number of records and any number of branch codes(N), as shown below:-

Input File:
001 ajdkjnekj 20 300
003 jdankjndv 5 100
001 ujedngvun 12 288
010 ojnhouiuu 10 900
. . . .
. . . .
002 iuygfyieu 50 200

Output File:
BID PID QTY PRICE
001 aahbfeue 10 400
001 aikdanho 20 100
. . . .
. . . .
001 ytqbuuuw 50 200
Total: 500 4000
002 athbfeue 15 300
002 ahkdanho 23 300
. . . .
. . . .
002 ztqbuuuw 52 100
Total: 500 6000
. . . .
. . . .
. . . .
N lsngjiei 999 999999
Total: 999 999999

I need to perform this using only JCL,DFSORT,ICETOOL without using Cobol or any other programming language.

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