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

Syncsort -Need Clarification during elimination of 1st Occur


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

New User


Joined: 11 Oct 2004
Posts: 69
Location: chennai

PostPosted: Fri Aug 13, 2010 3:16 pm
Reply with quote

Hi Alissa,

Thanks for the above control statements.I gave you the sample Input and Output file and for that your control card works fine.For my case the :
Input file1:
05.08.2010AAC770010860926-AAC10.08.201014.04.1710
05.08.2010AAC770010861027-AAC10.08.201014.04.1710
05.08.2010AAC7700111331MJ-AAC10.08.201014.04.1710
05.08.2010AAC7700111332MK-AAC10.08.201014.04.1710
05.08.2010AAC7700115267D6-AAC10.08.201014.04.1710
05.08.2010AAC7701716736UJ-AAC10.08.201014.04.1710
05.08.2010AAC820001918193-AAC10.08.201014.04.1710
05.08.2010AAC820001918395-AAC10.08.201014.04.1710
05.08.2010AAC82000328539C-AAC10.08.201014.04.1710
05.08.2010AAC82000380427A-AAC10.08.201014.04.1710

Input file 2:
05.08.2010AAC770010860926-AAC06.08.201003.26.1206
05.08.2010AAC770010861027-AAC06.08.201003.26.1206
05.08.2010AAC7700111331MJ-AAC06.08.201003.26.1206
05.08.2010AAC7700111332MK-AAC06.08.201003.26.1206
05.08.2010AAC7700115267D6-AAC06.08.201003.26.1206
05.08.2010AAC7701716736UJ-AAC06.08.201003.26.1206
05.08.2010AAC820001918193-AAC06.08.201003.26.1206
05.08.2010AAC820001918395-AAC06.08.201003.26.1206
05.08.2010AAC82000328539C-AAC06.08.201003.26.1206
05.08.2010AAC82000380427A-AAC06.08.201003.26.1206
05.08.2010APB8200557429N4-A/P06.08.201003.26.1206
05.08.2010APB8200557436NB-A/P06.08.201003.26.1206
05.08.2010APB8200557444NK-A/P06.08.201003.26.1206
05.08.2010APB8200557450NS-A/P06.08.201003.26.1206
05.08.2010APB8200954286NJ-A/P06.08.201003.26.1206
05.08.2010APN8200453975CN-A/P06.08.201003.26.1206
05.08.2010APN8200460684S9-A/P06.08.201003.26.1206
05.08.2010APN8200460688SD-A/P06.08.201003.26.1206
05.08.2010APN8200460704SW-A/P06.08.201003.26.1206
05.08.2010APN8200913073FJ-A/P06.08.201003.26.1206
05.08.2010APP8200463405BS-A/P06.08.201003.26.1206
05.08.2010APP8200463408BV-A/P06.08.201003.26.1206
05.08.2010APP8200463410BX-A/P06.08.201003.26.1206
05.08.2010APP8200463411BY-A/P06.08.201003.26.1206

Expected Output is:
05.08.2010AAC770010860926-AAC10.08.201014.04.1710
05.08.2010AAC770010861027-AAC10.08.201014.04.1710
05.08.2010AAC7700111331MJ-AAC10.08.201014.04.1710
05.08.2010AAC7700111332MK-AAC10.08.201014.04.1710
05.08.2010AAC7700115267D6-AAC10.08.201014.04.1710
05.08.2010AAC7701716736UJ-AAC10.08.201014.04.1710
05.08.2010AAC820001918193-AAC10.08.201014.04.1710
05.08.2010AAC820001918395-AAC10.08.201014.04.1710
05.08.2010AAC82000328539C-AAC10.08.201014.04.1710
05.08.2010AAC82000380427A-AAC10.08.201014.04.1710
05.08.2010APB8200557429N4-A/P06.08.201003.26.1206
05.08.2010APB8200557436NB-A/P06.08.201003.26.1206
05.08.2010APB8200557444NK-A/P06.08.201003.26.1206
05.08.2010APB8200557450NS-A/P06.08.201003.26.1206
05.08.2010APB8200954286NJ-A/P06.08.201003.26.1206
05.08.2010APN8200453975CN-A/P06.08.201003.26.1206
05.08.2010APN8200460684S9-A/P06.08.201003.26.1206
05.08.2010APN8200460688SD-A/P06.08.201003.26.1206
05.08.2010APN8200460704SW-A/P06.08.201003.26.1206
05.08.2010APN8200913073FJ-A/P06.08.201003.26.1206
05.08.2010APP8200463405BS-A/P06.08.201003.26.1206
05.08.2010APP8200463408BV-A/P06.08.201003.26.1206
05.08.2010APP8200463410BX-A/P06.08.201003.26.1206
05.08.2010APP8200463411BY-A/P06.08.201003.26.1206

The above control card gives me the output as:

05.08.2010AAC770010860926-AAC10.08.201014.04.1710
05.08.2010APB8200557429N4-A/P06.08.201003.26.1206
05.08.2010APB8200557436NB-A/P06.08.201003.26.1206
05.08.2010APB8200557444NK-A/P06.08.201003.26.1206
05.08.2010APB8200557450NS-A/P06.08.201003.26.1206
05.08.2010APB8200954286NJ-A/P06.08.201003.26.1206
05.08.2010APN8200453975CN-A/P06.08.201003.26.1206
05.08.2010APN8200460684S9-A/P06.08.201003.26.1206
05.08.2010APN8200460688SD-A/P06.08.201003.26.1206
05.08.2010APN8200460704SW-A/P06.08.201003.26.1206
05.08.2010APN8200913073FJ-A/P06.08.201003.26.1206
05.08.2010APP8200463405BS-A/P06.08.201003.26.1206
05.08.2010APP8200463408BV-A/P06.08.201003.26.1206
05.08.2010APP8200463410BX-A/P06.08.201003.26.1206
05.08.2010APP8200463411BY-A/P06.08.201003.26.1206

Below is the control card that i gave for my requirement:

//SYSIN DD *
JOINKEYS FILES=F1,FIELDS=(1,13,A)
JOINKEYS FILES=F2,FIELDS=(1,13,A)
JOIN UNPAIRED
REFORMAT FIELDS=(F1:1,106,F2:1,106)
INREC IFTHEN=(WHEN=(1,106,CH,EQ,C' '),BUILD=(107,106)),
IFTHEN=(WHEN=NONE,BUILD=(1,106))
SORT FIELDS=(1,13,CH,A)
SUM FIELDS=NONE
/*


I tried various options with your Control card but couldnt get the desired output.
Please help in this regard.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 496
Location: USA

PostPosted: Wed Aug 18, 2010 10:51 pm
Reply with quote

You should get the desired results if you change the SORT statement

from
Code:
SORT FIELDS=(1,13,CH,A)
to
Code:
SORT FIELDS=(1,106,CH,A)

Please let us know if this resolves the issue.
Back to top
View user's profile Send private message
srajanbose

New User


Joined: 11 Oct 2004
Posts: 69
Location: chennai

PostPosted: Mon Aug 23, 2010 2:21 pm
Reply with quote

Hi Alissa,

Thanks you so much.It works perfectly for me.

Regards,
Rajan BOSE.
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 Compare only first records of the fil... SYNCSORT 7
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts DFSORT/SYNCSORT/ICETOOL JCL & VSAM 8
No new posts Syncsort "Y2C" Function SYNCSORT 1
No new posts Arithmetic division using Syncsort SYNCSORT 6
Search our Forums:

Back to Top