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.
Generate Report of Product Information
Moderators: Frank Yaeger, Moderator Group
-
- Member
- Posts: 1
- Joined: Fri Mar 02, 2018 5:51 pm
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page