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

Syncsort - Join records but key at different positions


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Wed Jul 17, 2013 8:56 pm
Reply with quote

Unmatched records from File-2 into another output file.

Thanks.
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Thu Jul 18, 2013 1:53 pm
Reply with quote

Could you try modifying the sort to add an error file(ERR DD) as shown below?
Code:
....
...
//T1        DD DISP=(NEW,PASS),UNIT=SYSDA   
//OUT       DD SYSOUT=*                     
//ERR       DD SYSOUT=*                     
...
...
//CTL1CNTL  DD *                                           
...
...
 OUTFIL FNAMES=T1,INCLUDE=(87,1,CH,EQ,C'$')               
 OUTFIL FNAMES=ERR,SAVE,BUILD=(1,80)       
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Thu Jul 18, 2013 2:58 pm
Reply with quote

Hi,

Adding ERR has worked and writes unmatched from File-2.

Code:

01       VIZ913 XTRCT                        PGM00490  2009-07-12-21.21.06.03947
06       SEV5129108001012009ERRS01918.36.22.997000PAPMAER11VIZ913          29130
03       WIER 9550           VIZ913 %@##CMU                                     
05       01980                                   VIZ913                         


Thanks.
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Thu Jul 18, 2013 3:06 pm
Reply with quote

Thanks for letting know. icon_smile.gif
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 -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
No new posts JCL sortcard to print only the records DFSORT/ICETOOL 11
Search our Forums:

Back to Top