IBM Mainframe Forum

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

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.

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?

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.

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.

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?

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. . .

d

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
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

Thanks guys for the answer

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

d