IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Sort - Header on Page Break and Section Break


 
IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Mon May 13, 2013 12:01 pm
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Mon May 13, 2013 1:42 pm
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Mon May 13, 2013 4:17 pm
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Mon May 13, 2013 6:08 pm
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 All times are GMT + 6 Hours
Forum Index -> SYNCSORT
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
No new posts Copying data from prev record using SORT SYNCSORT 19
No new posts Combining more 4 files with sorted or... DFSORT/ICETOOL 3
No new posts Break a record into fields, each fiel... SYNCSORT 2
This topic is locked: you cannot edit posts or make replies. Parsing more than 1000 columns in a s... SYNCSORT 10

Back to Top