Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 7241

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: 7241

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: 7241

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: 7241

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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us