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

 MAINFRAME - TIP OF THE DAY : programming pearls - Good judgement comes from experience, and experience comes from bad judgement.

 Web mainframegurukul.com

Programmers Voted for below topics.      Please Vote for good Posts. Votes Salutes
Author Message

Member

Joined: 23 Dec 2013
Posts: 2

 0 salutes

 Posted: Mon Dec 23, 2013 11:02 am    Post subject: Addition of Amounts using Sort JCL Hi All, We have a requirement where we need to add the amounts according to the Country and accounting months. E.g. Input C1 01 10.00 C1 01 10.00 C1 02 50.00 C1 02 50.00 C1 03 70.00 C1 03 70.00 C2 01 20.00 C2 01 20.00 C2 02 30.00 C2 02 30.00 Output: C1 01 20.00 <-- Additing of amount for accounting month 01 C1 02 120.00 <--- Addition of amount for Accounting Month 01 and 02 C1 03 260.00 <--- Addition of amount for Accounting Month 01,02,03 C2 01 40.00 C2 02 100.00 We can easily sum up the amount as per Accounting month but the problem is to sum up amount for the current month with the all old accounting months. Not sure if it is possible through JCL. Any help is very much appriciated. Thanks in advance
 <-- Click on right mark icon. If this post answer your question.

Active Member

Joined: 24 May 2012
Posts: 714

 0 salutes

 Posted: Mon Dec 23, 2013 12:06 pm    Post subject: Are you saying you need cumulative figures by month? Can you check the fiigures in your example output?
 <-- Click on right mark icon. If this post answer your question.

Member

Joined: 23 Dec 2013
Posts: 2

 0 salutes

 Posted: Mon Dec 23, 2013 12:13 pm    Post subject: Yes William, I need the Cumulative figure by month, But it should be like for 02 month the sum will Cumulative sum of 01 + Cumulative sum of 02. For Month 03 the sum will Cumulative sum of 01 + Cumulative sum of 02 + Cumulative sum of 03. Like wise I checked the figures in the example are correct as per the above criteria. Not sure, if i am clear this time.
 <-- Click on right mark icon. If this post answer your question.

Active Member

Joined: 24 Jul 2011
Posts: 651
Location: Down on the pig farm

 0 salutes

 Posted: Mon Dec 23, 2013 10:40 pm    Post subject: Please not that "sort JCL" cannot do this. It can only tell the os that you want to run sort and it needs the resources specified in the JCL. Also note that there is a sort section of the forum (titled DFsor but is for all sort products). You need to specify which sort product you are using as the sort control cards required may differ depending on the sort product._________________Regards Nic
 <-- Click on right mark icon. If this post answer your question.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT + 5 Hours Page 1 of 1

 Jump to: Select a forum This Website----------------Admin AnnouncementsModerators Only APPLICATION PROGRAMMING----------------COBOLJCLDFSORT , ICETOOL & UtilitiesCICSEASYTRIEVE DATA MANAGEMENT SYSTEMS----------------DB2 SQL - DB2 PROGRAMMINGVSAM - File systemIMS DBIDMS TOOLS----------------XPEDITERFILE-AIDCHANGE MANENDEVOR, COOLGEN , PANVALET and CA-7 OTHER LANGUAGES----------------TSO, CLIST & REXXPL/IASSEMBLERIMS/DC CAREERS / JOBS DISCUSSIONS / INTERVIEW QUESTIONS----------------JOB VACANCIESJOB DISCUSSIONABEND CODES / ERROR CODESDB2 INTERVIEW QUESTIONSCOBOL INTERVIEW QUESTIONSJCL INTERVIEW QUESTIONSVSAM INTERVIEW QUESTIONSCICS INTERVIEW QUESTIONSINTERVIEW QUESTIONS OTHER MAINFRAME SUBJECTS----------------XMLMQSERIES & WEBSPHEREOTHER SUBJECTS GENERAL FORUMS----------------EntertainmentGeneral DiscussionPersonality DevelopmentOff TopicsSuggestions & Feedback
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

  Topics   Replies   Author   Views   Last Post Related topics Search Batch file-aid help 14 frenchman 31122 Mon Feb 01, 2016 10:23 pmacademyindia4 File-Aid Help 3 Nicholas 21039 Mon Feb 01, 2016 10:22 pmacademyindia4 Hi plz help me out 7 Guest 20834 Mon Feb 01, 2016 10:14 pmacademyindia4 Need urgent HELP 4 Sulagna 12205 Mon Feb 01, 2016 1:39 amacademyindia4 executing java program thru JCL 6 Guest 24197 Tue Feb 12, 2013 1:56 pmAnuj Dhawan

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