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

comapring datasets two more keys using ICETOOL


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
senmainframe
Currently Banned

New User


Joined: 09 Oct 2007
Posts: 30
Location: USA

PostPosted: Sat Oct 27, 2007 1:14 am
Reply with quote

In the following ICETOOL JCL, how I can mention more than one key fields. Currently I mentioned only one key field (2,6,CH). I need to compare two more fields with this (70,2,CH) & (52,2,CH)

Code:

//S1    EXEC  PGM=ICETOOL
//TOOLMSG DD SYSOUT=*                                           
//DFSMSG DD SYSOUT=*                                             
//CON DD DSN=CAA1035.FSLPLCRD.DELTA1,DISP=SHR                   
//    DD DSN=DCIA.B.BDAADBLD.AGTLICRC,DISP=SHR                   
//MATCH DD DSN=CAA1035.FSLPLCRD.DELTA1.MATCH,DISP=SHR           
//NOMATCH DD DSN=CAA1035.FSLPLCRD.DELTA1.NONMATCH,DISP=SHR       
//TOOLIN DD *                                                   
SELECT FROM(CON) TO(MATCH) ON(2,6,CH) ALLDUPS DISCARD(NOMATCH)   
/*
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Sat Oct 27, 2007 3:21 am
Reply with quote

Code:

SELECT FROM(CON) TO(MATCH) ON(2,6,CH) ON(70,2,CH) ON(52,2,CH) -
  ALLDUPS DISCARD(NOMATCH) 


The syntax for the DFSORT/ICETOOL SELECT operator is completely described with lots of examples at:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.11?DT=20060615185603

All of the DFSORT books are available online at:

Use [URL] BBCode for External Links
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Use input file with OMIT rcd keys? DFSORT/ICETOOL 15
Search our Forums:

Back to Top