 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 13 matches |
| Author | Message |
|---|---|
 Topic: DFSORT report with total and subtotal |
|
| balaryan Replies: 19 Views: 7504 |
 Forum: Utilities Posted: Mon Mar 27, 2017 10:40 am Subject: DFSORT report with total and subtotal |
| Is that elapsed time or cpu time?
Nic, Its CPU time. |
|
| Topic: DFSORT report with total and subtotal |
|
| balaryan Replies: 19 Views: 7504 |
Forum: Utilities Posted: Tue Mar 21, 2017 3:10 pm Subject: DFSORT report with total and subtotal |
| Kolusu,
I tested the latest solution and found the earlier one is quicker than latter. Solution #1 : 0.90 min Solution #2 : 1.25 min |
|
| Topic: DFSORT report with total and subtotal |
|
| balaryan Replies: 19 Views: 7504 |
Forum: Utilities Posted: Fri Mar 17, 2017 3:03 pm Subject: DFSORT report with total and subtotal |
|
Now I would like to check the CPU times for COBOL solution and SORT solution Yeah.. Very much impressed with DFSORT performance. It took less than a minute with the total of 0.90 min for both steps ... |
|
| Topic: DFSORT report with total and subtotal |
|
| balaryan Replies: 19 Views: 7504 |
Forum: Utilities Posted: Fri Mar 17, 2017 1:59 pm Subject: DFSORT report with total and subtotal |
| Hi Kolusu,
Your latest solution works very well as expected. Thanks a lot for your time and magnanimity in sharing your knowledge with me. Also, I am trying to understand the solution you provided. ... |
|
| Topic: Reformatting output file by including new field in Joinkeys |
|
| balaryan Replies: 7 Views: 2861 |
Forum: Utilities Posted: Thu Mar 16, 2017 3:49 pm Subject: Reformatting output file by including new field in Joinkeys |
| @Kolusu,
Thanks. I got it now and it workz. |
|
| Topic: DFSORT report with total and subtotal |
|
| balaryan Replies: 19 Views: 7504 |
Forum: Utilities Posted: Thu Mar 16, 2017 2:48 pm Subject: DFSORT report with total and subtotal |
| Hi Kolusu,
Existing program takes 180 secs approx to generate the report from the 40 millions record of an input file. I tried your solution and each record getting repeated several times (dups) sa ... |
|
| Topic: Reformatting output file by including new field in Joinkeys |
|
| balaryan Replies: 7 Views: 2861 |
Forum: Utilities Posted: Thu Mar 16, 2017 11:02 am Subject: Reformatting output file by including new field in Joinkeys |
| Hi Kolusu,
Apologies for using the same topic to post my query which was based on the initial problem. Is it possible to sort the output file as a result of this JOINKEYS with two fields in ASC and ... |
|
| Topic: DFSORT report with total and subtotal |
|
| balaryan Replies: 19 Views: 7504 |
Forum: Utilities Posted: Wed Mar 15, 2017 8:26 am Subject: DFSORT report with total and subtotal |
| Hi Kolusu,
I always respect the help and information you provided here. I would like to inform that this is purely for my understanding of DFSORT and ICETOOL and won't be misusing the information y ... |
|
| Topic: Reformatting output file by including new field in Joinkeys |
|
| balaryan Replies: 7 Views: 2861 |
Forum: Utilities Posted: Tue Mar 14, 2017 5:48 pm Subject: Reformatting output file by including new field in Joinkeys |
Thanks Kolusu for the detailed information which helped me in understanding the concept of JOINKEYS. Appreciate your help and time in providing valuable info.  |
|
| Topic: DFSORT report with total and subtotal |
|
| balaryan Replies: 19 Views: 7504 |
Forum: Utilities Posted: Tue Mar 14, 2017 5:45 pm Subject: DFSORT report with total and subtotal |
| Hi Kolusu,
Apologies for not providing suffice information. I had provided the required information below. Input records hold millions of records and in sorted order. There will be several tho ... |
|
| Topic: Reformatting output file by including new field in Joinkeys |
|
| balaryan Replies: 7 Views: 2861 |
Forum: Utilities Posted: Tue Mar 14, 2017 4:00 pm Subject: Reformatting output file by including new field in Joinkeys |
| Hi kolusu,
Your as usual amazing. Thanks for the solution. I wonder how you see things simple always. 
I also would like to take this opportunity in understanding the solution you provided. ... |
|
| Topic: Reformatting output file by including new field in Joinkeys |
|
| balaryan Replies: 7 Views: 2861 |
Forum: Utilities Posted: Mon Mar 13, 2017 3:47 pm Subject: Reformatting output file by including new field in Joinkeys |
| Hello,
I am having an issue in understanding the depth of JOINKEYS. I am trying to compare and merge two input files (each file having different layout) which are in SORTED order and populate the n ... |
|
| Topic: DFSORT report with total and subtotal |
|
| balaryan Replies: 19 Views: 7504 |
Forum: Utilities Posted: Mon Mar 13, 2017 2:05 pm Subject: DFSORT report with total and subtotal |
| Hi All,
I am trying to generate the desired report using the below-listed input. |6003| 1|N|A| |6003| 1|N|A| |6003| 1|Y|A| |6003| 1|N|A| |6003| 2|Y|A| |6003| 2|N|A| |6003| 2|Y|A| |6003| 2 ... |
|
All times are GMT - 5 Hours |