Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SYNTAX ERROR in OUTFIL statment in my SORT job

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: SYNTAX ERROR in OUTFIL statment in my SORT job
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    Post subject:
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: 1703
Location: Australia

PostPosted: Wed Nov 26, 2008 3:24 pm    Post subject:
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    Post subject:
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: 1703
Location: Australia

PostPosted: Wed Nov 26, 2008 3:36 pm    Post subject:
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    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Wed Nov 26, 2008 4:41 pm    Post subject:
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: 2285
Location: @my desk

PostPosted: Wed Nov 26, 2008 6:58 pm    Post subject:
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    Post subject:
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: 2285
Location: @my desk

PostPosted: Thu Nov 27, 2008 4:01 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 0 Mon Sep 18, 2017 4:31 pm
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 5 Thu Sep 07, 2017 6:02 pm
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm

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