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

Syncsort Issue with a sort card in placing a new field
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Raghunadhareddy.J

New User


Joined: 26 Apr 2011
Posts: 6
Location: INDIA
PostPosted: Wed Apr 27, 2011 12:37 pm
 Reply with quote
MY Input to sort is as follows.

"04/18/11","ADJ","0008054","0000012","MDVW",000.14
"04/18/11","INV","0696135","0002872","MDVW",000.41
"04/18/11","ADJ","0008054","0000012","NPDA",000.14
"04/18/11","INV","0696135","0002872","NPDA",000.41
"04/18/11","ADJ","0008054","0000012","VRNE",000.14
"04/18/11","INV","0696135","0002872","VRNE",000.41
"04/18/11","ADJ","0008054","0000012","VRNY",000.14
"04/18/11","INV","0696135","0002872","VRNY",000.41

My job is abending with user code U0016.

The job I'm using is
Code:
//STEP010  EXEC PGM=SORT                                               
//SYSOUT   DD SYSOUT=*                                                 
//SORTIN   DD DSN=V924503.VIBE.RPT.GDERPT.SORT7,                                   
//         DISP=SHR                                                   
//SORTOUT  DD DSN=V924503.VIBE.RPT.GDERPT.EMAIL.C333,                 
//         DISP=(,CATLG,DELETE),                                       
//         UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE)                           
//SYSIN    DD *                                                       
  SORT FIELDS=(13,3,A,39,4,A),FORMAT=CH                               
  OUTFIL HEADER1=(1:'         VIBE - INVOICES RECEIVED           ',/, 
                  1:'        --------------------------          ',2/,
              1:'DATE      AREA  TYPE    GUIDED     UNGUIDED    % ',/,
              1:'-----     ----  ----    ------     --------   ----'),
  OUTREC=(1:2,8,X,11:39,4,X,17:13,3,X,21:19,7,ZD,EDIT=(II,III,IIT),   
          35:29,7,ZD,EDIT=(I,III,IIT),42:45,6,31X),                   
  SECTIONS=(13,3,SKIP=0L,                                             
  TRAILER3=(/,1:'TOTAL',21:TOT=(19,7,ZD,EDIT=(II,III,IIT)),           
             35:TOT=(29,7,ZD,EDIT=(I,III,IIT)),/)),                   
  TRAILER1=(1:'TOTAL INVOICES',21:TOT=(19,7,ZD,EDIT=(II,III,IIT)),     
             35:TOT=(29,7,ZD,EDIT=(I,III,IIT)),/),                     
       LINES=56                                                       
/*


42:45,6,

The above given is the new code added to outrec to place the last field in input to output.

job is abending with user return code U0016.
WER108I SORTIN : RECFM=FB ; LRECL= 50; BLKSIZE= 27950
WER136A SORTOUT OUTREC HAS OVERLAPPING FIELDS SPECIFIED

Thanks & regards
Raghu
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
PostPosted: Wed Apr 27, 2011 12:53 pm
 Reply with quote
What on earth is it about the description of the problem given by the product that you do not understand
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
PostPosted: Wed Apr 27, 2011 3:21 pm
 Reply with quote
Revisit your outrec statement... you have mentioned overlapping fields...

Opps... I thought of explaining what the issue is but ended up very same as SYNCSORT has told... icon_sad.gif..

I think thats the simplest one can tell about issue..
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
PostPosted: Wed Apr 27, 2011 3:52 pm
 Reply with quote
The problem is that he is using SYNCSORT not DFSORT so posting in the DFSORT part of the forum is bound to produce an error.

Another problem is that he failed to analyse the message that came up when he started to post - post in the relevant section and delete the message.
Back to top
View user's profile Send private message
Raghunadhareddy.J

New User


Joined: 26 Apr 2011
Posts: 6
Location: INDIA
PostPosted: Thu Apr 28, 2011 4:24 pm
 Reply with quote
Hi All,

Thanks a lot for your quick responce.
I got the issue and fixed it.

This is the outrec statement worked for me.
OUTREC=(1:2,8,X,11:39,4,X,17:13,3,X,21:19,7,ZD,EDIT=(II,III,IIT),
35:29,7,ZD,EDIT=(I,III,IIT),X,45:45,5,31X),

Thanks & regards
Raghu
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 Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us