Synctool - NoDUPS

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

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

shankar.v · Posted: Wed Apr 08, 2009 9:51 pm

cvishu,

dick scherrer · Posted: Thu Apr 09, 2009 1:05 am

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.

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

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

Arun Raj · Posted: Thu Apr 09, 2009 8:47 pm

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

This is the content

Arun Raj · Posted: Thu Apr 09, 2009 9:20 pm

AFAIK the INCLUDE and SORT of your DYNMCNTL card will be performed before the SELECT and the OUTREC part after the SELECT.