Generate Report of Product Information
Posted: 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.
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.