Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Synctool - NoDUPS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
cvishu

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Wed Apr 08, 2009 6:10 pm    Post subject: Synctool - NoDUPS
Reply with quote

I have two input files - Input and datefile .
I'm creating a dynamic sortcard using the datefile - DYNMCNTL
In CTL1CNTL I have the necessary dynamic card creation statements to create the outputfile.

//TOOLIN DD *
COPY FROM(DATEFILE) USING(CTL1)
SORT FROM(OUTPUT) TO(OUTPUT1) USING(DYNM)

--------------------------
It works perfectly fine.

but when I try to elimnate duplicates using NODUPS
COPY FROM(DATEFILE) USING(CTL1)
SELECT FROM(INPUT) TO(OUTPUT) ON(102,20,CH) NODUPS USING (DYNM)

when i execute it i get an empty output file... though there are eligble records
Back to top
View user's profile Send private message

shankar.v

Active User


Joined: 25 Jun 2007
Posts: 196
Location: Bangalore

PostPosted: Wed Apr 08, 2009 9:51 pm    Post subject:
Reply with quote

cvishu,

Quote:
but when I try to elimnate duplicates using NODUPS

NODUPS will select records whose ON field occurs only once.

I think, you have to use FIRST instead of NODUPS to discard duplicate entries on ON field.

Thanks,
Shankar
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Apr 09, 2009 1:05 am    Post subject:
Reply with quote

Hello,

If this is not yet working, suggest you post the complete jcl and sort control info and the informational output created when the sort was executed.
Back to top
View user's profile Send private message
cvishu

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Thu Apr 09, 2009 8:05 pm    Post subject:
Reply with quote

i want to know for the below statement will NODUPS get executed first or
DYNM cntlcard will be executed first

SELECT FROM(INPUT) TO(OUTPUT) ON(102,20,CH) NODUPS USING (DYNM)


Shankar, u r correct , i indeed want to remove all duplicates present in ON
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Thu Apr 09, 2009 8:47 pm    Post subject:
Reply with quote

Quote:
i want to know for the below statement will NODUPS get executed first or DYNM cntlcard will be executed first
Can be decided only if you show us what is inside your DYNMCNTL card.
Back to top
View user's profile Send private message
cvishu

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Thu Apr 09, 2009 8:55 pm    Post subject:
Reply with quote

This is the content
Code:
SORT FIELDS=(1,9,CH,A,49,1,CH,A,186,3,CH,A,17,9,CH,A)
INCLUDE COND=(39,5,PD,EQ,90317,AND,                   
             99,1,CH,NE,C'1',AND,                     
             138,4,CH,NE,C'0001',AND,                 
             645,3,CH,EQ,C'980',AND,                 
             17,3,CH,NE,C'980',AND,                   
             (1677,1,CH,EQ,C'N',OR,                   
              1677,1,CH,EQ,C'F'))                     
OUTREC FIELDS=(1:1,9,10:17,9,19:34,5,24:39,5,         
              29:49,1,30:50,10,40:60,10,50:71,1,     
              51:73,1,52:79,6,58:186,3,               
              61:358,8,69:623,4,80:X)     
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Thu Apr 09, 2009 9:20 pm    Post subject:
Reply with quote

AFAIK the INCLUDE and SORT of your DYNMCNTL card will be performed before the SELECT and the OUTREC part after the SELECT.
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 SYNCTOOL better than SYNCSORT? Amit_Singh SYNCSORT 3 Wed Jul 23, 2014 11:06 am
No new posts Can any one give me any sample join s... Sanath sekhar Reddy N SYNCSORT 9 Thu Aug 08, 2013 12:03 pm
No new posts SyncSort/SyncTooL to extract records ... Hariharan BK SYNCSORT 25 Tue Jun 04, 2013 2:42 pm
No new posts Work files with SYNCTOOL mlp JCL & VSAM 3 Wed Oct 05, 2011 11:10 am
No new posts Two copies of a file in a single pass... Raymond Sachs JCL & VSAM 2 Fri Sep 09, 2011 11:36 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us