Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-24 Thread Hobart Spitz
alle > > Youtube channel: https://www.youtube.com/channel/UCu_65HaYgksbF6Q8SQ4oOvA > > > > From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 23/09/2020 17:18 > Subject:[EXTERNAL] Re: SORT question: H

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-23 Thread Martin Packer
o: IBM-MAIN@LISTSERV.UA.EDU Date: 23/09/2020 17:18 Subject:[EXTERNAL] Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output? Sent by:IBM Mainframe Discussion List On Wed, 23 Sep 2020 16:01:08 +0100, Martin Packer wrote: >Right.

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-23 Thread Paul Gilmartin
On Wed, 23 Sep 2020 16:01:08 +0100, Martin Packer wrote: >Right. That example used BatchPipes/MVS pipes - but it's not essential to >the use of OUTFIL SPLIT. The reason it used pipes was to enable cloning to >balance a pipe. > OK. I looked at your example (z/OS 2.1; not too misty). But what mys

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-23 Thread Martin Packer
, Peter x23353" <031df298a9da-dmarc-requ...@listserv.ua.edu> To: IBM-MAIN@LISTSERV.UA.EDU Date: 23/09/2020 14:54 Subject: [EXTERNAL] Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output? Sent by:IBM Mainframe Discu

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-23 Thread Farley, Peter x23353
-MAIN@LISTSERV.UA.EDU Subject: Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output? EXTERNAL EMAIL OUTFIL SPLIT. Something also from the mists of time, by no coincidence, is this: https://urldefense.com/v3/__https://www.ibm.com/support

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-23 Thread Martin Packer
Date: 22/09/2020 20:34 Subject: [EXTERNAL] Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output? Sent by:IBM Mainframe Discussion List > On the "tagging" that Sri Hari mentioned: > > 1) You needn't tag unles

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-23 Thread Martin Packer
r.fm/marna-walle Youtube channel: https://www.youtube.com/channel/UCu_65HaYgksbF6Q8SQ4oOvA From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> To: IBM-MAIN@LISTSERV.UA.EDU Date: 22/09/2020 20:31 Subject:[EXTERNAL] Re: SORT question: How to both remove recor

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-22 Thread Sri h Kolusu
> On the "tagging" that Sri Hari mentioned: > > 1) You needn't tag unless you want to - and there will be some occasions > where you don't want to. Matrin, Fully agreed. I just wanted to show case with IFTHEN it is much easier to split into multiple files with different conditions. > Just some

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-22 Thread Paul Gilmartin
On Tue, 22 Sep 2020 20:08:12 +0100, Martin Packer wrote: > >SAVE has, to my mind, been most invaluable. Prior to this you had to >figure out the boolean complement of the INCLUDE= clause. With more than >one INCLUDE= clause in a sort it became hairier, requiring De Morgan's >Law*. :-) SAVE made th

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-22 Thread Martin Packer
://anchor.fm/marna-walle Youtube channel: https://www.youtube.com/channel/UCu_65HaYgksbF6Q8SQ4oOvA From: Sri h Kolusu To: IBM-MAIN@LISTSERV.UA.EDU Date: 22/09/2020 19:24 Subject: [EXTERNAL] Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output? S

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-22 Thread Farley, Peter x23353
Thanks Sri, that is just what I need. Peter -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri h Kolusu Sent: Tuesday, September 22, 2020 2:24 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SORT question: How to both remove records from a file AND write removed

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-22 Thread Sri h Kolusu
> In one pass of an input file is there a way to use SORT to both > remove identified records from an input file AND write those removed > records to a second output file? Peter, You don't need 2 passes of data, you can tag the records that match your identification and then use that tag to filt

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-22 Thread Farley, Peter x23353
Thanks Max, that would seem to be the way. Peter -Original Message- From: IBM Mainframe Discussion List On Behalf Of Massimo Biancucci Sent: Tuesday, September 22, 2020 1:44 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SORT question: How to both remove records from a file AND write

Re: SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-22 Thread Massimo Biancucci
Peter, look at OUTFIL syntax and SAVE keyword. Regards. Max Mail priva di virus. www.avast.com

SORT question: How to both remove records from a file AND write removed records to a 2nd output?

2020-09-22 Thread Farley, Peter x23353
In one pass of an input file is there a way to use SORT to both remove identified records from an input file AND write those removed records to a second output file? I know I can run two passes of the input using INCLUDE in pass 1 to select just the records to be removed and a second pass using