Get duplicate out from a Dataset.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Post Reply
Chetan Kakkar
Registered Member
Posts: 12
Joined: Wed Dec 11, 2013 1:34 pm

Get duplicate out from a Dataset.

Post by Chetan Kakkar »

Hi,

I have a Dataset with millions of records and I need to copy it to a VSAM file. For this new VSAM file the decide key is the 1 to 9 characters. There are multiple records in the input file with the same 1-9 characters.

I need to create a list of records which have the same 1 to 9 characters, how can I do that? A SORT suggestion will be fine for me.
User avatar
Anuj Dhawan
Founder
Posts: 2802
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: Get duplicate out from a Dataset.

Post by Anuj Dhawan »

Hi Chetan,

Do you need the duplicate keys also in a separate file?
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

Re: Get duplicate out from a Dataset.

Post by zprogrammer »

Hi Chetan,

You could try ICETOOL SELECT operator
zprogrammer
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”