Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Sort - Header on Page Break and Section Break

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
srinathds83

New User


Joined: 17 Jul 2007
Posts: 41
Location: pune

PostPosted: Mon May 13, 2013 11:31 am    Post subject: Sort - Header on Page Break and Section Break
Reply with quote

Hi,

I need the report to print header either after 60 lines(Page Break) or if Account type changes(Section Break).

Below sort card is working perfectly when account type changes but not printing the header after 60 lines.

Code:
 SORT FIELDS=COPY                                               
OUTFIL FNAMES=RPT,LINES=60,                                   
  SECTIONS=(1,4,SKIP=P,                                         
   HEADER3=(1:'DATE : ',9:DATE=(MD4-),31:'ACCOUNTING SYSTEM',
            68:'PAGE :',PAGE,/,                                 
            21:'REPORT OF THE ACCOUNTS',2/,     
            30:'ACCOUNT TYPE : ',1,4,2/,                   
            05:'ACCOUNT NUMBER',                                 
            25:'ACCOUNT HOLDER NAME ',/),                                   
   TRAILER3=(/,                                                 
     2:'TOTAL  : ',                           
     29:COUNT=(EDIT=(IIIT)),2/)),                               
   OUTREC=(05:10,10,                                           
           25:26,30)         


Please provide a solution where after 60 lines report header also prints.

Thanks,
Srinath
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Mon May 13, 2013 12:01 pm    Post subject: Reply to: Sort - Header on Page Break and Section Break
Reply with quote

Can you try with HEADER1 instead of HEADER3?
Back to top
View user's profile Send private message
srinathds83

New User


Joined: 17 Jul 2007
Posts: 41
Location: pune

PostPosted: Mon May 13, 2013 12:42 pm    Post subject: Re: Reply to: Sort - Header on Page Break and Section Break
Reply with quote

Hi,

Bill Woodger wrote:
Can you try with HEADER1 instead of HEADER3?


I tried using HEADER1 instead of HEADER 3. It shows Syntax error.

Code:
JCP0482E   WER268A  OUTFIL STATEMENT  : SYNTAX ERROR


Thanks
Srinath
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Mon May 13, 2013 1:42 pm    Post subject: Reply to: Sort - Header on Page Break and Section Break
Reply with quote

In HEADER1 you put the stuff which can never change.

In HEADER3 you put the stuff which changes in your SECTIONS.
Back to top
View user's profile Send private message
srinathds83

New User


Joined: 17 Jul 2007
Posts: 41
Location: pune

PostPosted: Mon May 13, 2013 2:53 pm    Post subject: Re: Reply to: Sort - Header on Page Break and Section Break
Reply with quote

Bill Woodger wrote:
In HEADER1 you put the stuff which can never change.

In HEADER3 you put the stuff which changes in your SECTIONS.


'ACCOUNT TYPE :' is the part of header and it keeps on changing. my requirement is to get it on every page.
Page break should happen if ACCOUNT TYPE changes or 60 lines for the same ACCOUNT TYPE crosses.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Mon May 13, 2013 4:17 pm    Post subject: Reply to: Sort - Header on Page Break and Section Break
Reply with quote

Should be HEADER2, not HEADER1 :-)

Have a look at your SyncSort manual. There's a PAGEHEAD on SECTIONS. You may need HEADER2 for it to work, but if so perhaps try HEADER2 with just a blank, so the actual header is from HEADER3.
Back to top
View user's profile Send private message
srinathds83

New User


Joined: 17 Jul 2007
Posts: 41
Location: pune

PostPosted: Mon May 13, 2013 6:00 pm    Post subject: Re: Reply to: Sort - Header on Page Break and Section Break
Reply with quote

Bill Woodger wrote:
Should be HEADER2, not HEADER1 :-)

Have a look at your SyncSort manual. There's a PAGEHEAD on SECTIONS. You may need HEADER2 for it to work, but if so perhaps try HEADER2 with just a blank, so the actual header is from HEADER3.


Thanks Bill.... Just by adding PAGEHEAD keyword, i got the desired result.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Mon May 13, 2013 6:08 pm    Post subject: Reply to: Sort - Header on Page Break and Section Break
Reply with quote

Thanks for letting us know.

Next time, manual first, then colleagues, then forum...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem while trying to manipulate re... amitc23 DFSORT/ICETOOL 3 Tue Jun 30, 2020 1:19 pm
No new posts Insert System Runtime in HEADER In SY... Rick Ryan SYNCSORT 9 Tue May 26, 2020 9:01 pm
No new posts Sort on different fields, removing du... MOHIT KUMAR GUPTA SYNCSORT 8 Thu Apr 16, 2020 5:54 pm
No new posts Please help - SORT with SUM fields an... clearskynot DFSORT/ICETOOL 6 Thu Apr 09, 2020 11:01 am
No new posts Create Header Dtae as MMDDYYYY thesumitk DFSORT/ICETOOL 16 Tue Feb 25, 2020 4:56 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us