IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Problem with SYNCSORT report writing


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
akshathan

New User


Joined: 18 Aug 2006
Posts: 45

PostPosted: Thu Apr 05, 2007 4:35 pm
Reply with quote

Hi all,

I wrote a jcl for generating a simple report using SYNCSORT.The code

Code:
                                     
//PS010  EXEC PGM=SORT                                             
//SYSOUT   DD SYSOUT=*                                             
//SORTIN   DD DSN=B052AKN.XSCM201.SCXFILE3,DISP=SHR                 
//REPTOUT  DD SYSOUT=*                                             
//SYSIN    DD *                                                     
  INCLUDE COND=(31,1,CH,EQ,C'S')                                   
  SORT FIELDS=(45,2,ZD,A)                                           
  SUM FIELDS=(94,6,PD)                                             
  OUTFIL FNAMES=REPTOUT,LINES=12,                                   
  HEADER2=(3:'CATEGORY',18:'PAY-AMT',/),                           
  OUTREC=(3:45,2,ZD,EDIT=(IIIT),18:94,6,PD,EDIT=(IITT.TT),30:X,/), 
  TRAILER2=(/,3:'--------',18:'-------',/,                         
    3:'TOTALS',18:TOT=(94,6,PD,EDIT=(ITTTT.TT)),/)                 
/*   


The problem i am facing is in REPTOUT ddname i am not able to give PDS name because its is giving the following error

25,648K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
0 BYTES RESERVE REQUESTED, 2M BYTES USED
SORTIN : RECFM=FB ; LRECL= 550; BLKSIZE= 27500
OUTREC RECORD LENGTH = 8
REPTOUT RECFM=F/FB, LRECL/BLKSIZE INVALID
REPTOUT RECFM INCOMPATIBLE WITH REPORT WRITING
REPTOUT : RECFM=FB ; LRECL= 133; BLKSIZE= 27500
REPTOUT HAS INCOMPATIBLE LRECL
CONVERT FEATURE CANNOT BE USED WITH OVERLAY OR IFTHEN
SYNCSMF CALLED BY SYNCSORT; RC=0000

If i am giving
//REPTOUT DD SYSOUT=* its working fine (as i have mentioned in the above JCL)

but with a pds name its giving the above mentioned errors.I tried a lot ,but not able to resolve this .Please guide me.

Regards
Akshatha
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Thu Apr 05, 2007 4:37 pm
Reply with quote

What are the characteristics of thePDS ? RECFM & LRECL
Back to top
View user's profile Send private message
vkphani

New User


Joined: 29 Oct 2003
Posts: 29

PostPosted: Thu Apr 05, 2007 4:47 pm
Reply with quote

Create a file with same characteristics as B052AKN.XSCM201.SCXFILE3 and give that as your output file.
Back to top
View user's profile Send private message
akshathan

New User


Joined: 18 Aug 2006
Posts: 45

PostPosted: Thu Apr 05, 2007 5:17 pm
Reply with quote

Hi Vkphani,

I tried by giving a file with same characteristics before posting ,this is what i got in the sysout.Please go through this


WER164B 25,648K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 2M BYTES USED
WER108I SORTIN : RECFM=FB ; LRECL= 550; BLKSIZE= 27500
WER107A REPTOUT RECFM INCOMPATIBLE WITH REPORT WRITING
WER110I REPTOUT : RECFM=FB ; LRECL= 550; BLKSIZE= 27500
WER247A REPTOUT HAS INCOMPATIBLE LRECL
WER425A CONVERT FEATURE CANNOT BE USED WITH OVERLAY OR IFTHEN
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000

regards,
Akshatha
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Thu Apr 05, 2007 5:23 pm
Reply with quote

I don't have SYNCSORT, so I can only guess, but the messages:

REPTOUT RECFM=F/FB, LRECL/BLKSIZE INVALID
REPTOUT RECFM INCOMPATIBLE WITH REPORT WRITING
REPTOUT : RECFM=FB ; LRECL= 133; BLKSIZE= 27500
REPTOUT HAS INCOMPATIBLE LRECL

seem pretty clear. I would presume that, since you are creating a report, that the expected output format would be RECFM=FBA, LRECL=133. It would appear that your dataset is not defined as such.
Back to top
View user's profile Send private message
vkphani

New User


Joined: 29 Oct 2003
Posts: 29

PostPosted: Thu Apr 05, 2007 5:54 pm
Reply with quote

Akshatha,

Please delete your output file and give it as the output file with DISP=(NEW,CATLG,DELETE) but DO NOT give LRECL. That will solve your problem I guess.

Try that and let us know.
Back to top
View user's profile Send private message
akshathan

New User


Joined: 18 Aug 2006
Posts: 45

PostPosted: Thu Apr 05, 2007 7:13 pm
Reply with quote

Hi Superk and vkphani,

Thanks for your replies.I got the out put as i wanted.I didnt specify the record length and changed the RECFM from FB to FBA as mentioned by Superk.

Initially i tried to run the JCL without specifying record length (mentioned by Vkphani),once again it ended with sam error 'incompatible record length' for report writing. Then tried with record length andRECFM= FBA still got the same error.At last i tried with no LRECL value and giving RECFM=FBA i got the out put.I dont know what logic is behind this.Could you please explain.

I want some information about FBA.

Thanks Onceagain!!
regards
Akshatha
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Two input files & writing counter... DFSORT/ICETOOL 12
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
Search our Forums:

Back to Top