SEPARE UNIQUE RECORDS



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

SEPARE UNIQUE RECORDS

Postby LisAndkp » Wed Jan 08, 2020 3:20 am

Hi,

I want your help for this question:

I have a File with these records:

A
A
B
C
C
C
C
D

and I want to have 2 files as output : 1 with the records which don't have duplicates and another with records duplicadates ,

like this

OUTPUT 1 :

B
D

OUTPUT 2 :

A
A
C
C
C
C

I want a solution using JCL and no using a program. I tried using XSUM but I didn't have what I want

Thanks for your help :)
LisAndkp
 
Posts: 1
Joined: Fri Dec 15, 2017 10:03 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SEPARE UNIQUE RECORDS

Postby NicC » Wed Jan 08, 2020 3:40 am

You cannot doing it with JCL as JCL does not manipulate data - it simply tells the operating system what program(s) you want to execute and the resources required. You need to execute a program, whether it is a utility eg a sort program or one you write yourself.

BTW, XSUM is not a JCL keyword. However, it would appear to be a Syncsort keyword so I will move the topic there.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: SEPARE UNIQUE RECORDS

Postby sergeyken » Wed Jan 08, 2020 7:47 pm

LisAndkp wrote:I want a solution using JCL and no using a program. I tried using XSUM but I didn't have what I want

Thanks for your help :)

1) XSUM has as little relation to JCL as to plain English, or to any other language (except Chinese)

2) In order to get ANY HELP you MUST demonstrate what you have done already?
Where is your code?

This is a HELP forum, but not DO-MY-JOB-FOR-ME forum.
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 409
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post