OnlineKnowledgeRepository


For Questions and Assistance please use the proper Category.. please..
 
HomeCalendarFAQSearchMemberlistUsergroupsRegisterLog in
Welcome guys!!.. In order for you guys to post your Questions and assistance requests,, please REGISTER first.. Only members can post.. If you have requests then feel free to email ADMIN neuron or SPAMMER onatzky.. thanks!
Search
 
 

Display results as :
 
Rechercher Advanced Search
Donation box
Latest topics
» Convert signed ZD to PD
Remove Duplicates in a dataset though Sort EmptyThu Sep 01, 2016 7:57 pm by neuron

» Abia State Polytechnic Admission form for 2013/2014 out!
Remove Duplicates in a dataset though Sort EmptyTue Oct 08, 2013 9:30 am by stevejoo

» Convert ZD to SIGNED PD
Remove Duplicates in a dataset though Sort EmptySun Sep 08, 2013 9:22 pm by neuron

» How to Speed Up My PC
Remove Duplicates in a dataset though Sort EmptyTue Feb 26, 2013 9:15 am by alphysudaria143

» Hi I'm alphysudaria143
Remove Duplicates in a dataset though Sort EmptySun Feb 17, 2013 12:25 am by alphysudaria143

» How to Copy all the Generations of a GDG
Remove Duplicates in a dataset though Sort EmptyThu Oct 11, 2012 8:30 am by neuron

» Remove Duplicates in a dataset though Sort
Remove Duplicates in a dataset though Sort EmptyThu Oct 11, 2012 8:23 am by neuron

» how to insert data into your access database vb.net
Remove Duplicates in a dataset though Sort EmptyTue Aug 14, 2012 9:56 am by neuron

» how to populate combobox in vb.net during form load
Remove Duplicates in a dataset though Sort EmptyTue Aug 14, 2012 9:53 am by neuron

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
Help
Please support me my registering to NEOBUX
advertisements
Remove Duplicates in a dataset though Sort Banner3
Affiliates
free forum
 



Share
 

 Remove Duplicates in a dataset though Sort

Go down 
AuthorMessage
neuron
Administrator
Administrator
neuron

Posts : 38
Join date : 2009-08-06

Remove Duplicates in a dataset though Sort Empty
PostSubject: Remove Duplicates in a dataset though Sort   Remove Duplicates in a dataset though Sort EmptyThu Oct 11, 2012 8:23 am

//sysin dd *
sort fields=(1,10,ch,a)
sum fields=none
*
//*

sort fields=(1,10,ch,a)

- this means that you are sorting position 1 with length 10 telling mainframe that the values inside will be treated as characters and arrange it in ascending order. In using the above dd statement, the mainframe will use the keys(1,10) and remove other records with the same value.


Sample:

dataset contains the following values

0000000001AAAA
0000000001AAAA
0000000001AAAA
0000000001AAAA
0000000002AAAA
0000000002BAAA
0000000002BAAA
0000000001AAAA

using the DD statement above, the sortout dataset will contain

0000000001AAAA
0000000002AAAA
0000000002BAAA


_________________
credit goes to the original uploader of the codes..

In this forum we will share the knowledge we have to every single individual who shows respect and interest.. If you stay.. you learn.. if not.. then please go.........

--it's me Admin"D"
Back to top Go down
View user profile http://myonlinekr.forumotion.com
 
Remove Duplicates in a dataset though Sort
Back to top 
Page 1 of 1
 Similar topics
-
» binding the strongman..?
» Band to sleeve in 1 operation
» Boilermate III - Working ok until thermostat kicks in and top leds start pulsing ?
» Boilermate 2000 only heating to 70 degrees C.
» Lundi 9 janvier : On sort ce soir ?

Permissions in this forum:You cannot reply to topics in this forum
OnlineKnowledgeRepository :: All About PC :: Programming :: MAINFRAME :: JCL-
Jump to: