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

Doubt in JCL SORT
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
sumivel

New User


Joined: 13 Sep 2005
Posts: 18
PostPosted: Thu Oct 13, 2005 10:40 am
 Reply with quote
can any one give me a jcl TO SORT a file CMMS.M750.TRANS FROM COL 3 TO COL13,EXCLUDE RECORD IF THE CONTENT IS TH SAME DUPLICATE KEY
Back to top
View user's profile Send private message
sridevi2005

New User


Joined: 15 Sep 2005
Posts: 42
PostPosted: Thu Oct 13, 2005 11:12 am
 Reply with quote
Hi,

Try the following code

SORT FIELDS=(3,10,CH,A)
SUM FIELDS=NONE

Sum fields = none will drop the dupliacte records.

If u have any quesry on this please let me know.

Thanks & Regards
Sridevi
Back to top
View user's profile Send private message
sumivel

New User


Joined: 13 Sep 2005
Posts: 18
PostPosted: Thu Oct 13, 2005 11:51 am
 Reply with quote
Thanks sri devi...
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 Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us