Page 1 of 1

SEPARE UNIQUE RECORDS

PostPosted: Wed Jan 08, 2020 3:20 am
by LisAndkp
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 :)

Re: SEPARE UNIQUE RECORDS

PostPosted: Wed Jan 08, 2020 3:40 am
by NicC
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.

Re: SEPARE UNIQUE RECORDS

PostPosted: Wed Jan 08, 2020 7:47 pm
by sergeyken
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.