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 One-One matching using SORT dearlux SYNCSORT 11 Fri Oct 11, 2019 12:11 am
No new posts Create Dynamic Sort card with Omit co... balaji81_k DFSORT/ICETOOL 9 Thu Sep 26, 2019 10:06 pm
No new posts Header and trailer for a PS file kumara kanthirava JCL & VSAM 5 Mon Aug 19, 2019 3:54 pm
No new posts need assistance on a sort rajiv rengasamy SYNCSORT 11 Fri Jul 26, 2019 8:19 pm
No new posts need help with a tricky sort - Continued rajiv rengasamy SYNCSORT 8 Tue Jul 16, 2019 1:26 pm

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