Home      Mainframe Forum      Mainfarme Tutorials      IBM Manuals      Mainframe Interview Questions      Mainframe Books      IT News     SiteMap     Downloads


     
 
MAINFRAME - TIP OF THE DAY : All available storage is assigned to the job or jobstep, If REGION is coded 0K or 0M

Google
 
Web mainframegurukul.com

Sort to split into 3 files with sum fields at GROUP level

 
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> DFSORT , ICETOOL & Utilities
  View previous topic :: View next topic  
Author Message
nmr4u
Member


Joined: 05 Jan 2015
Posts: 1
Location: India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Tue Jan 06, 2015 2:18 pm    Post subject: Sort to split into 3 files with sum fields at GROUP level Reply with quote

Input file:
Code:
                205099                                            <
                                        42964205//          443ABC
              000000000                   964205830000000000   4201
               ........                   9642054452907309110024201             13
               ........                   9642054452797319210004201             13
                205099                                            <
                                        42907205//          445ABC
              000000000                   907205830000000000   4201
               ........                   9072053652907795010084201             13
               ........                   9072053652797805110044201             13

Controls:
1. Position 67 = "<" indicates Header level 1.
2. Position 64 to 66 = "ABC" indicates Header level 2.
3. Position 51 to 60 filled with zeroes indicate Header level 3.
4. Other records are detail records.
5. The input file needs to be split into 3 files based on the value in the detail records' position 49-54 as per the following data member.
Code:
000000 147000 532 F1
147001 314000 843 F2
314001 423000 334 F3
423001 547578 897 F1
547579 747000 234 F3
747001 748000 885 F1
748001 999999 174 F2

Layout for the above data:
Position 1 to 6 = Range start value
Position 8 to 13 = Range end value
Position 15 to 17 = Control number
Position 19 to 20 = Output file number

As per the match for detail records' position 49-54 in the above said ranges, the "Control number" & output split file number are identified.
6. In the output file, all three headers are required in all the split files.
7. On the appropriate split file, replace position 61 to 63 on Header level 2 with "Control number".
8. On the appropriate split file, for Header level 3 position 15 to 23 (comp-3), populate the sum of detail records' position 16 to 23 (comp-3).
9. If there is no detail record for a specific header record bunch, the header record bunch should not be written to the output file.
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.

ShivanoTE
Member


Joined: 18 Dec 2014
Posts: 7

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Wed Jan 07, 2015 7:29 pm    Post subject: Reply with quote

Can you show us how the 3 output files should be? Also add the 'cols' line to see better the input file.
_________________
"No hay fé sin sangre."
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Harlemsr
Member


Joined: 18 Feb 2015
Posts: 2
Location: bkk

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Wed Feb 18, 2015 2:53 pm    Post subject: Reply with quote

This knowledge led me to publish it.
_________________
บาคาร่าออนไลน์
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Display posts from previous:   
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> DFSORT , ICETOOL & Utilities All times are GMT + 5 Hours
Page 1 of 1



 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Related topics
 Topics   Replies   Author   Views   Last Post 
No new posts United Health group Interview ? 4 need@help 9893 Fri Jan 15, 2016 8:35 pm
academyindia4 View latest post
No new posts Sort file by groups, keeping only the last group 7 TamiAZ 8365 Fri Oct 02, 2009 11:24 am
TamiAZ View latest post
No new posts What do you accomplish by GROUP BY ... HAVING clause? 1 Krishna 3928 Sun Mar 29, 2009 10:13 pm
Krishna View latest post
No new posts can i write a elementary item to group item. 1 mainframe5 4444 Tue Jun 17, 2008 1:47 pm
dbzTHEdinosauer View latest post
No new posts Why is Group move better than INITIALIZE verb? 1 NiceGuy 5892 Mon Nov 19, 2007 6:52 am
DavidatK View latest post
 


Cobol Tutorial
This cobol tutorial covers most of the important topics like STRING, UNSTRING, COMP, COMP-3.....
DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. Explains in simple language. Some Chapters are locked, Forum members have free access to these chapters
CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming...
JCL Tutorial
This is most popular JCL tutorial from mainframegurukul. It does contain important jcl ....
SORT Tutorial
This Tutorial covers all important aspects of DFSORT. Has more SORT examples
INTERVIEW Questions
This page covers important interview questions
Mainframe Jobs
Mainframe Jobs posted by members of mainframegurukul forum
FaceBook Page
MainframeGurukul FaceBook Page
LinkedIn Page
MainframeGurkul Linkedin Page

This widget requires Flash Player 9 or better







Go to top of the page
 

Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  DB2 INTERVIEW QUESTIONS ||  COBOL INTERVIEW QUESTIONS  ||  JCL INTERVIEW QUESTIONS ||  JCL2 INTERVIEW QUESTIONS ||  VSAM INTERVIEW QUESTIONS ||  CICS INTERVIEW QUESTIONS  ||  Online tutorials ||  Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap  ||  Expeditor Tutorial  ||  FILE-AID Tutorial  ||  Changeman Tutorial  ||  COBOL   ||  DB2   ||  JCL  ||  CICS  ||  VSAM  ||  DB2 Interview Questions ( 110 )   || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1 ;|| Mainframe Forum - Tutorials  || Mainframe Tutorials || Mainframe CICS tutorial|| Mainframe COBOL Tutorial

Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Powered by phpBB

mainframetopic-7802.html