Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Synsort shows on the same outfile as the joined records
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Tue May 24, 2011 8:59 pm    Post subject:
Reply with quote

It would be nice if you show us some sample input records frm both the file and the expected output from that.
Back to top
View user's profile Send private message

ken herbolic

New User


Joined: 24 Jan 2011
Posts: 16
Location: buffalo

PostPosted: Tue May 24, 2011 9:20 pm    Post subject:
Reply with quote

thanks for all the help....sync sort support has shown me the problem with my code....the below is a working sample for anyone that may have a simiplar need.
Code:

JOINKEYS FILE=F1,FIELDS=(1,9,A)                               
JOINKEYS FILE=F2,FIELDS=(1,9,A)                               
JOIN UNPAIRED                                                 
REFORMAT FIELDS=(F1:1,9,10,51,F2:1,9,10,58),FILL=X'40'         
OUTREC IFTHEN=(WHEN=(1,1,BI,EQ,X'40'),BUILD=(61,9,51X,70,58)),
       IFTHEN=(WHEN=(NONE),BUILD=(1,60,70,58))                 
SORT FIELDS=COPY                                               
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
Goto page Previous  1, 2
Page 2 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need SQL for two latest records havin... Q5P418 DB2 10 Sun May 10, 2020 8:24 am
No new posts Compare Two datasets and Override Mat... ArunkumarGanesan DFSORT/ICETOOL 7 Mon Apr 27, 2020 7:45 pm
No new posts Splice multiple records into single r... sarankriya DFSORT/ICETOOL 4 Wed Apr 15, 2020 10:55 pm
No new posts Include Group record based on detail ... guptae DFSORT/ICETOOL 11 Thu Mar 12, 2020 1:54 pm
No new posts Compare input date as YYMMDD with the... Khurshid_Khan SYNCSORT 5 Fri Feb 21, 2020 10:28 pm

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