Utility to merge 2 PS file without duplication of records.



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Utility to merge 2 PS file without duplication of records.

Postby ashwin1990 » Thu Jun 07, 2012 7:52 pm

hi

Can we merge two PS files, using sort utility, without duplication of records???

Or is there any other utility that can be used for mergiing two PS files but without duplication??

Thanks
ashwin1990
 
Posts: 32
Joined: Mon Feb 27, 2012 4:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Utility to merge 2 PS file without duplication of records.

 

Re: Utility to merge 2 PS file without duplication of record

Postby dick scherrer » Thu Jun 07, 2012 8:47 pm

Hello,

Yes, you can remove duplicates using your sort product. It is probably the best alternative (depending on the actual requirement).

You need to post a representative sample of the input data and the output you want from your process.

Show duplicates in one or both input files (wherever they might occur) and mention the recfm and lrecl of all files.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Utility to merge 2 PS file without duplication of record

Postby NicC » Thu Jun 07, 2012 10:37 pm

And if you were wanting to do it with sort - why on earth did you post in the JCL section of the forum and not the section of the forum appropriate to your sort product?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Utility to merge 2 PS file without duplication of record

Postby dick scherrer » Thu Jun 07, 2012 11:27 pm

Hi Nic,

Because very many of our users consider control statements to be jcl . . .

I don't know who started this, but i'd suspect it was clueless teachers or managers . . .

If TS will tell us which sort product, i'll move this to that part of the forum.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Utility to merge 2 PS file without duplication of record

Postby NicC » Fri Jun 08, 2012 1:54 am

Hi Dick,

yes - but the more we tell the more that might actually listen and start correcting their colleagues. I believe it stems from people saying things alonfg the lines of 'just run a JCL' so JCL becomes a magic do it all. Sort of similar to, I believe, Americans (US versions) saying 'run it through the IBM' where IBM meant the computer.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Utility to merge 2 PS file without duplication of record

Postby Akatsukami » Fri Jun 08, 2012 2:05 am

NicC wrote:I believe it stems from people saying things alonfg the lines of 'just run a JCL' so JCL becomes a magic do it all. Sort of similar to, I believe, Americans (US versions) saying 'run it through the IBM' where IBM meant the computer.

I've spent the past thirty-years in American IT and have never once heard that locution. Are you sure you're not looking at the map in a mirror? ;)
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Utility to merge 2 PS file without duplication of record

Postby dick scherrer » Fri Jun 08, 2012 2:24 am

Hi Nic,

The last time i heard "run it thru the IBM" was at an insurance company where a big brandnew 7070 was installed (my first "IT" job). Before that everything used "tab" equipment (card-in, card-out and/or paper-out). Once the mainframe arrived, lots of things were never the same. . .


yes - but the more we tell the more that might actually listen and start correcting their colleagues
Yup, i agree! I do repeat this often, but sometimes feel like i'm a nag.

Now if we can find a way to cause it to change. . .

Along with versions for generations.

And bunches of database stuff. . .


Ok, i'll go quietly now. . . :oops:

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Utility to merge 2 PS file without duplication of record

Postby NicC » Fri Jun 08, 2012 3:21 am

Are you sure you're not looking at the map in a mirror?

God, or whatever, help us if the world looked like my face :lol:
As I have not really been to the US I would only have seen it on TV or in a film - and some time ago at that - I think it was in black and white (so it must be true). Anyway, 30 years is only to the dawn of the IBM compatible PC - real modern, almost this century :D
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Utility to merge 2 PS file without duplication of record

Postby ashwin1990 » Mon Jun 11, 2012 9:31 am

Thanks guys for the answer
ashwin1990
 
Posts: 32
Joined: Mon Feb 27, 2012 4:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Utility to merge 2 PS file without duplication of record

Postby dick scherrer » Mon Jun 11, 2012 10:18 pm

You're welcome - but do you have a working solution?

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post