how to break header 3 for each 55 lines using sort
how to break header 3 for each 55 lines using sort
by cuteshanthim » Sat Sep 08, 2012 1:41 pm
For each 55 lines, the report header 2 is breaked through LINES = 55. But I want to break the header 3 for each 55 lines.... Can you help to resolve this....
- cuteshanthim
- Posts: 8
- Joined: Thu Mar 22, 2012 5:02 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: how to break header 3 for each 55 lines using sort
by NicC » Sat Sep 08, 2012 2:31 pm
I do not even understand the question so suggest you post sample input and output.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
Regards
Nic
- NicC
- Global moderator
- Posts: 3025
- Joined: Sun Jul 04, 2010 12:13 am
- Location: Pushing up the daisies (almost)
- Has thanked: 4 times
- Been thanked: 136 times
Re: how to break header 3 for each 55 lines using sort
by cuteshanthim » Sat Sep 08, 2012 2:41 pm
The following is the report layout.... i want all the headings for each 55 lines break.
The below is the sort card I am using....
160-22650 DEALER DISTRIBUTION SYSTEM DATE: 09/08/12 PAGE: 1
JOB-PGM SUMMARY REPORT RUN: 09/08/12 01:49:40
REGION: 160 DISTRICT: 1
MONTH: 03/2012
SERIES: ALL
NO NET
MATCH MATCH MONTHLY
COUNT COUNT SALES
31110 DEALER1 0 1 1
31121 DEALER2 0 1 1
------ ------ ------
DISTRICT 161 TOTAL 0 2 2
** INDICATES COMBINED PRIMARY AND COMPANION STORE(S).
160-22650 DEALER DISTRIBUTION SYSTEM DATE: 09/08/12 PAGE: 2
JOB-PGM SUMMARY REPORT RUN: 09/08/12 01:49:40
REGION: 160 DISTRICT: 3
MONTH: 03/2012
SERIES: ALL
NO NET
MATCH MATCH MONTHLY
COUNT COUNT SALES
29059 DEALER3 0 1 1
29085 DEALER4 0 1 1
------ ------ ------
DISTRICT 163 TOTAL 0 2 2
** INDICATES COMBINED PRIMARY AND COMPANION STORE(S).
JOB-PGM SUMMARY REPORT RUN: 09/08/12 01:49:40
REGION: 160 DISTRICT: 1
MONTH: 03/2012
SERIES: ALL
NO NET
MATCH MATCH MONTHLY
COUNT COUNT SALES
31110 DEALER1 0 1 1
31121 DEALER2 0 1 1
------ ------ ------
DISTRICT 161 TOTAL 0 2 2
** INDICATES COMBINED PRIMARY AND COMPANION STORE(S).
160-22650 DEALER DISTRIBUTION SYSTEM DATE: 09/08/12 PAGE: 2
JOB-PGM SUMMARY REPORT RUN: 09/08/12 01:49:40
REGION: 160 DISTRICT: 3
MONTH: 03/2012
SERIES: ALL
NO NET
MATCH MATCH MONTHLY
COUNT COUNT SALES
29059 DEALER3 0 1 1
29085 DEALER4 0 1 1
------ ------ ------
DISTRICT 163 TOTAL 0 2 2
** INDICATES COMBINED PRIMARY AND COMPANION STORE(S).
The below is the sort card I am using....
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=INPUT FILE,DISP=SHR
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(2,3,A,5,1,A,12,5,A)),FORMAT=CH
INREC IFTHEN=(WHEN=(42,1,CH,EQ,C'C'),OVERLAY(65:C'**')),
IFTHEN=(WHEN=(42,1,CH,EQ,C' '),OVERLAY(65:C' ')),
IFTHEN=(WHEN=(1,1,CH,NE,C' '),
OVERLAY(55:43,4,ZD,ADD,47,4,ZD,M10,LENGTH=4))
OUTFIL REMOVECC,
OUTREC=(/,2:12,5,8:65,2,11:17,25,45:43,4,ZD,56:47,4,ZD,
68:55,4,ZD,M10,LENGTH=4,132:X),
SECTIONS=(2,3,5,1,SKIP=P,
HEADER3=(2:2,3,5:'-22650',
35:'DEALER DISTRIBUTION SYSTEM',
105:'DATE: ',&DATE,121:'PAGE: ',&PAGE,/,
2:'JOB-PGM',
35:'SUMMARY REPORT',
106:'RUN: ',&DATE,121:&TIME,/,
35:'REGION: ',2,3,65:'DISTRICT: ',5,1,/,
35:'MONTH: ',6,2,44:'/',8,4,/,
2:'SERIES: ALL',/,
46:'NO',69:'NET',/,
45:'MATCH',56:'MATCH',67:'MONTHLY',/,
45:'COUNT',56:'COUNT',68:'SALES'),
TRAILER3=(132:X,/,
44:'------',55:'------',67:'------',2/,
6:'DISTRICT ',17:2,2,19:5,1,31:'TOTAL ',
45:TOTAL=(43,04,ZD,M10,LENGTH=4),
56:TOTAL=(47,04,ZD,M10,LENGTH=4),
68:TOTAL=(55,04,ZD,M10,LENGTH=4),2/,
/,2:'** INDICATES COMBINED PRIMARY AND COMPANION STORE(S).',
80:X))
//*
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=INPUT FILE,DISP=SHR
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(2,3,A,5,1,A,12,5,A)),FORMAT=CH
INREC IFTHEN=(WHEN=(42,1,CH,EQ,C'C'),OVERLAY(65:C'**')),
IFTHEN=(WHEN=(42,1,CH,EQ,C' '),OVERLAY(65:C' ')),
IFTHEN=(WHEN=(1,1,CH,NE,C' '),
OVERLAY(55:43,4,ZD,ADD,47,4,ZD,M10,LENGTH=4))
OUTFIL REMOVECC,
OUTREC=(/,2:12,5,8:65,2,11:17,25,45:43,4,ZD,56:47,4,ZD,
68:55,4,ZD,M10,LENGTH=4,132:X),
SECTIONS=(2,3,5,1,SKIP=P,
HEADER3=(2:2,3,5:'-22650',
35:'DEALER DISTRIBUTION SYSTEM',
105:'DATE: ',&DATE,121:'PAGE: ',&PAGE,/,
2:'JOB-PGM',
35:'SUMMARY REPORT',
106:'RUN: ',&DATE,121:&TIME,/,
35:'REGION: ',2,3,65:'DISTRICT: ',5,1,/,
35:'MONTH: ',6,2,44:'/',8,4,/,
2:'SERIES: ALL',/,
46:'NO',69:'NET',/,
45:'MATCH',56:'MATCH',67:'MONTHLY',/,
45:'COUNT',56:'COUNT',68:'SALES'),
TRAILER3=(132:X,/,
44:'------',55:'------',67:'------',2/,
6:'DISTRICT ',17:2,2,19:5,1,31:'TOTAL ',
45:TOTAL=(43,04,ZD,M10,LENGTH=4),
56:TOTAL=(47,04,ZD,M10,LENGTH=4),
68:TOTAL=(55,04,ZD,M10,LENGTH=4),2/,
/,2:'** INDICATES COMBINED PRIMARY AND COMPANION STORE(S).',
80:X))
//*
- cuteshanthim
- Posts: 8
- Joined: Thu Mar 22, 2012 5:02 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: how to break header 3 for each 55 lines using sort
by cuteshanthim » Sat Sep 08, 2012 2:53 pm
I have given all the headers in HEADER3 section because I want all the headers to be displayed in the report for the changes in Region and District. Now I want all the headers to be displayed in the report, when the line reaches 55. Can you please help me out.
- cuteshanthim
- Posts: 8
- Joined: Thu Mar 22, 2012 5:02 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: how to break header 3 for each 55 lines using sort
by cuteshanthim » Sat Sep 08, 2012 4:02 pm
LINES=55 options is applicable for header2 (page header). I want the break for each 55 lines in the report header (HEADER3).....If we give LINES=55 in the OUTFIL, then it will not impact the report since I have not used header2.
- cuteshanthim
- Posts: 8
- Joined: Thu Mar 22, 2012 5:02 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: how to break header 3 for each 55 lines using sort
by cuteshanthim » Sat Sep 08, 2012 5:07 pm
Any one give some solution....
- cuteshanthim
- Posts: 8
- Joined: Thu Mar 22, 2012 5:02 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: how to break header 3 for each 55 lines using sort
by enrico-sorichetti » Sat Sep 08, 2012 5:49 pm
Any one give some solution....
why should we ?
do not solicit for answers
You must understand that ...
replying on a forum is
on voluntary base
on our own time
free of charge
therefore
there is no commitment on our side
there should be no expectation on Your side
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
- enrico-sorichetti
- Global moderator
- Posts: 3006
- Joined: Fri Apr 18, 2008 11:25 pm
- Has thanked: 0 time
- Been thanked: 165 times
Re: how to break header 3 for each 55 lines using sort
by dick scherrer » Sun Sep 09, 2012 1:22 am
Hello and welcome to the forum,
Keep in mind that you get help for free here. If you were paying for support, you might expect something, but most pay for support sometimes takes a while also.
Also, consider that this is the weekemd and many are not online now.
If you are working on something you want this weekend, suggest you try a different approach where the current limitation does not apply. If not with sort, a program would be trivial, but you would have the answer quickly,
Asking for more replies after only a few hours is rather inconsiderate.Any one give some solution....
Keep in mind that you get help for free here. If you were paying for support, you might expect something, but most pay for support sometimes takes a while also.
Also, consider that this is the weekemd and many are not online now.
If you are working on something you want this weekend, suggest you try a different approach where the current limitation does not apply. If not with sort, a program would be trivial, but you would have the answer quickly,
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Return to DFSORT/ICETOOL/ICEGENER
-
- Related topics
- Replies
- Views
- Last post
-
- Counting lines and replacing only header on a file
by hrobert09 » Wed Feb 18, 2009 4:41 pm - 2 Replies
- 2611 Views
- Last post by hrobert09
Thu Feb 19, 2009 8:53 pm
- Counting lines and replacing only header on a file
-
- Set of 6 lines need to copy using SORT
by Purush » Wed Apr 09, 2014 11:06 pm - 4 Replies
- 5008 Views
- Last post by BillyBoyo
Fri Apr 11, 2014 6:25 pm
- Set of 6 lines need to copy using SORT
-
- Add the header to the all output file in sort
by varadhu » Sat Jun 06, 2009 9:32 am - 2 Replies
- 4483 Views
- Last post by Frank Yaeger
Sat Jun 06, 2009 7:51 pm
- Add the header to the all output file in sort
-
- I want to remove header and trailer using sort
by pgkkreddy1 » Wed Jan 24, 2018 12:13 pm - 6 Replies
- 8789 Views
- Last post by Aki88
Sat Feb 10, 2018 12:41 am
- I want to remove header and trailer using sort
-
- SORT card to reformat header date
by ninudvictor » Thu Nov 20, 2008 10:02 am - 4 Replies
- 4063 Views
- Last post by ninudvictor
Sat Nov 22, 2008 6:29 pm
- SORT card to reformat header date