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

SYNTAX ERROR in OUTFIL statment in my SORT job


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

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Wed Nov 26, 2008 3:00 pm
Reply with quote

Hi, I have the following error being shown on the OUTFIL statment in my SORT job, can anybody tell me what I am doing wrong ?

Code:

OUTFIL HEADER2=(30:'J A Y S   R E P O R T   O N  IYUIOS 5',/,
                                                                                         *
                35: 'LAST PURCHASES MADE IN 2003',//,       
                02: 'NAME',/,                               
                26: 'STREET ADDRESS',/,                     
               52: 'CITY',/,                                 
              68: 'STATE',/,                                 
              75: 'DATE',/)                                 


The error seems to be near the Asterix shown above.

thanks.
Back to top
View user's profile Send private message
JayC

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Wed Nov 26, 2008 3:01 pm
Reply with quote

The asterix is actually under the last comma in the first line of the OUTFIL statement.
Sorry about the editing.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Wed Nov 26, 2008 3:24 pm
Reply with quote

Hi,

please show original code and messages.


Gerry
Back to top
View user's profile Send private message
JayC

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Wed Nov 26, 2008 3:30 pm
Reply with quote

Original Code
----------------
Code:

//STEP100   EXEC PGM=SORT                                   
//SYSOUT    DD SYSOUT=*                                     
//*                                                         
//SORTJNF1  DD DISP=SHR,DSN=SS6848.SORTFILE.TRANFILE.INSAMP 
//*                                                         
//SORTJNF2  DD DISP=SHR,DSN=SS6848.SORTFILE.NAMEADDR.INSAMP 
//SYSIN DD *                                                 
 JOINKEYS FILE=F1,FIELDS=(15,10,A)                           
  INCLUDE COND=(25,6,Y2T,GE,Y'030101')                       
 JOINKEYS FILE=F2,FIELDS=(01,10,A)                           
 REFORMAT FIELDS=(F2:1,67,F1:25,6)                           
 SORT FIELDS=(1,10,BI,A),EQUALS                             
 SUM FIELDS=NONE                                             
 OUTFIL HEADER2=(30:'J A Y S   R E P O R T   O N  IYUIOS 5'/,
                 35: 'LAST PURCHASES MADE IN 2003',//,       
                 02: 'NAME',/,                               
                 26: 'STREET ADDRESS',/,                     
                52: 'CITY',/,                               
               68: 'STATE',/,                               
               75: 'DATE',/)                                 
         OUTREC=(02:11,20,                                   
                 26:31,20,                                   
                 52:51,15,                                   
                 68:68,2,                                   
                 73:70,2,C'/',72,2,C'/',68,2)               
/*                                                           


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

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Wed Nov 26, 2008 3:36 pm
Reply with quote

Hi,

you seem to have a space after 35: 02: to 75:


Gerry
Back to top
View user's profile Send private message
abhishek dadhichi

New User


Joined: 19 Apr 2007
Posts: 37
Location: Bangalore

PostPosted: Wed Nov 26, 2008 3:51 pm
Reply with quote

Hi Jayc,

I feel the line:
30:'J A Y S R E P O R T O N IYUIOS 5'/, should be
30:'J A Y S R E P O R T O N IYUIOS 5',/,




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

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Wed Nov 26, 2008 4:36 pm
Reply with quote

Thanks ABhishek and Gerry. One more thing, I have the following messages after I made the corrections :
Code:

WER164B  17,644K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B     0 BYTES RESERVE REQUESTED, 420K BYTES USED             
WER146B  20K BYTES OF EMERGENCY SPACE ALLOCATED                   
WER481I  JOINKEYS REFORMAT RECORD LENGTH=   73, TYPE = F           
WER107A  SORTOUT  RECFM INCOMPATIBLE WITH REPORT WRITING           
WER110I  SORTOUT  : RECFM=FB   ; LRECL=    80; BLKSIZE= 27920     
WER247A  SORTOUT  HAS INCOMPATIBLE LRECL                           

Is there a particular RECFM that we need to use for report writing ?
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Wed Nov 26, 2008 4:41 pm
Reply with quote

Have you bothered to check the error messages and codes in the manuals to get some ideas ?
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Wed Nov 26, 2008 6:58 pm
Reply with quote

JayC,

What is your output file format?
Back to top
View user's profile Send private message
JayC

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Thu Nov 27, 2008 3:12 pm
Reply with quote

My output file format is FB.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Thu Nov 27, 2008 4:01 pm
Reply with quote

JayC,

Add the REMOVECC parameter to your OUTFIL statement without which Syncsort assumes your Output file format to be xBA.
Code:
 OUTFIL REMOVECC,HEADER2=.......
Back to top
View user's profile Send private message
JayC

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Mon Dec 01, 2008 12:29 pm
Reply with quote

Thanks Arun, it worked.
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 Help with SORT - I need to validate d... DFSORT/ICETOOL 0
No new posts IEW2315E 1369 Link error All Other Mainframe Topics 3
No new posts Help on IMS -API URL migrating from P... IMS DB/DC 1
No new posts JCL sort to compare dates in two file... DFSORT/ICETOOL 2
No new posts Is this possible via sort (in one pass)? SYNCSORT 4
Search our Forums:

Back to Top