Re: SORT question: Extract varying length string adding suffix after string?

Thanks a lot Cameron! SQZ=(VL) did the trick. BUILD=(1,4,C'PREFIX DATA:',%00,SQA=(VL),C':SUFFIX DATA') Peter -Original Message- From: IBM Mainframe Discussion List On Behalf Of Cameron Conacher Sent: Saturday, April 2, 2022 4:53 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SORT

Re: SORT question: Extract varying length string adding suffix after string?

If I understand things correctly, you could use Squeeze (SQZ) to eliminate the embedded blanks. Something like SQZ=(SHIFT=LEFT). Maybe you will need another SORT step to squeeze the entire record? Thanks, ...Cameron From: IBM Mainframe Discussion List On Behalf Of Farley, Peter x23353

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

> 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: How to both

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

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?

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

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

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

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

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

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

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

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 rec

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

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

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

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

ube 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? Sent by:IBM Mainframe D

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

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?

> 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

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

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?

Peter, look at OUTFIL syntax and SAVE keyword. Regards. Max Mail priva di virus. www.avast.com

BLOCK CONTAINS on non-VSAM was Re: Sort Question

fined. Clark Morris > >HTH > >Peter > >-Original Message- >From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On >Behalf Of Tim Hare >Sent: Tuesday, October 10, 2017 11:19 PM >To: IBM-MAIN@LISTSERV.UA.EDU >Subject: Re: Sort Question > &

Re: Sort Question

[mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Tim Hare Sent: Tuesday, October 10, 2017 11:19 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Sort Question I know I am late to this, but I see no BLOCK CONTAINS 0 RECORDS in the COBOL. I'm not totally current on COBOL releases, but A) is that still

Re: Sort Question

On Tue, 10 Oct 2017 22:18:47 -0500, Tim Hare wrote: >I know I am late to this, but I see no BLOCK CONTAINS 0 RECORDS in the COBOL. >I'm not totally current on COBOL releases, but >A) is that still required to use block size from the JCL > Even better, it will use the block size supplied by

Re: Sort Question

I know I am late to this, but I see no BLOCK CONTAINS 0 RECORDS in the COBOL. I'm not totally current on COBOL releases, but A) is that still required to use block size from the JCL B) is it even relevant in this instance - COBOL will use the block size value of the dataset that's input, yes?

Re: Sort Question

Thanx Dave! From: David Betten <bet...@us.ibm.com> To: IBM-MAIN@LISTSERV.UA.EDU Date: 10/02/2017 09:45 AM Subject: Re: Sort Question Sent by:IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> I see a couple things the DFSORT output The reason f

Re: Sort Question

> -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Paul Gilmartin > Sent: 03 October, 2017 15:28 > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Sort Question > > On Tue, 3 Oct 2017 06:42:38 +, Verno

Re: Sort Question

On Tue, 3 Oct 2017 06:42:38 +, Vernooij, Kees (ITOPT1) - KLM wrote: >> > >> But does this contend adversely with concurrent jobs? > >DFSORT communicates with RSM in order to utilize memory efficiently, without >overloading it. > Then might installations' second-guessing result in imposing

Re: Sort Question

> > > But does this contend adversely with concurrent jobs? > DFSORT communicates with RSM in order to utilize memory efficiently, without overloading it. Kees. For information, services and offers, please visit our web site:

Re: Sort Question

Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Elardus Engelbrecht Sent: Monday, October 02, 2017 3:33 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Sort Question Pfister, Nathan wrote: >That said, by setting MOSIZE to 0...it fixed the issue as was with no other >changes.

Re: Sort Question

On Mon, 2 Oct 2017 13:02:24 -0500, Elardus Engelbrecht (elardus.engelbre...@sita.co.za) wrote about "Re: Sort Question" (in <4916708819685726.wa.elardus.engelbrechtsita.co...@listserv.ua.edu>): [snip] > AFAIK, COBOL has its own internal SORT functions, It does not. Both

Re: Sort Question

Pfister, Nathan wrote: >That said, by setting MOSIZE to 0...it fixed the issue as was with no other >changes. Right, wrong, or indifferent. Interesting. You changed to 0 from MOSIZE = MAX (from you earlier post where you listed the sort parameters)? Hmmm, interesting, but thanks. Good to

Re: Sort Question

Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Clark Morris Sent: Monday, October 02, 2017 3:19 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Sort Question [Default] On 2 Oct 2017 11:01:13 -0700, in bit.listserv.ibm-main elardus.engelbre

Re: Sort Question

[Default] On 2 Oct 2017 11:01:13 -0700, in bit.listserv.ibm-main elardus.engelbre...@sita.co.za (Elardus Engelbrecht) wrote: >Paul Gilmartin wrote: > >You have made good points, thanks. > > >>> With respect to the REGION size, remember that SORT (both IBM and its >>> competitors) is most

Re: Sort Question

Paul Gilmartin wrote: You have made good points, thanks. >> With respect to the REGION size, remember that SORT (both IBM and its >> competitors) is most efficient the more memory you can let him have. I have >> found this especially true for COBOL-based SORT's. >But does this contend

Re: Sort Question [AD - Kind of]

Blaicher, Christopher Y. wrote: >Syncsort's MFX sort when using the Global Sort Monitor measures systems >resources, both on an instantaneous basis and on a historical basis to judge >how much memory each sort should use. I wish with a really sore heart that all applications and compiled

Re: Sort Question [AD - Kind of]

@LISTSERV.UA.EDU Subject: Re: Sort Question > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > On Behalf Of Paul Gilmartin > Sent: Monday, October 02, 2017 12:24 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Sort Question

Re: Sort Question

On Mon, 2 Oct 2017 16:48:39 +, Farley, Peter x23353 wrote: >> >> Does DFSORT rely on QSAM or on idiosyncratic EXCP? I'd expect that in the >> era of oscillating merge it relied on EXCP. > >Of course SORT uses his own EXCP (or OCO media manager interfaces) where >possible, as it is far more

Re: Sort Question

> -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Paul Gilmartin > Sent: Monday, October 02, 2017 12:24 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Sort Question > > On 2017-10-02, at 09:29, Fa

Re: Sort Question

On 2017-10-02, at 09:29, Farley, Peter x23353 wrote: > With respect to the REGION size, remember that SORT (both IBM and its > competitors) is most efficient the more memory you can let him have. I have > found this especially true for COBOL-based SORT's. > But does this contend adversely

Re: Sort Question

rmance IBM Corporation email: bet...@us.ibm.com IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 10/02/2017 03:57:35 PM: > From: "Pfister, Nathan" <nathanpfis...@donegalgroup.com> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 10/02/2017 03:57 PM > Subject

Re: Sort Question

email: bet...@us.ibm.com IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 10/02/2017 03:57:35 PM: > From: "Pfister, Nathan" <nathanpfis...@donegalgroup.com> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 10/02/2017 03:57 PM > Subject: Re: Sort Question &

Re: Sort Question

On Behalf Of Pfister, Nathan Sent: Monday, October 02, 2017 11:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Sort Question Lizette; Thanks for that suggestion. For now, I looked at what you have and I will give some similar cards a shot. Also, I didn't realize I could reach out to the D

Re: Sort Question

Subject: Re: Sort Question Some interesting sections from DFSORT messages 1) DSA is set to 128 in parms but DSA=0 is in the sort message output 2) DFSORT at failure says an additional 44 WORK volumes were needed There is a way to pass parms to DFSORT using DFSPARM DD statement For our

Re: Sort Question

AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Sort Question > > Pfister, Nathan wrote: > > >Sorry for the long post, but here's all the info. > >Here's the jobs output: > > >ICE092I 0 MAIN STORAGE = (128000,1048576,1048576) ICE156I 0 MAIN > >STORAGE

Re: Sort Question

Pfister, Nathan wrote: >Sorry for the long post, but here's all the info. >Here's the jobs output: >ICE092I 0 MAIN STORAGE = (128000,1048576,1048576) >ICE156I 0 MAIN STORAGE ABOVE 16MB = (590271,590271) It is looking small for me, at least for me. What is your job REGION? Is that REGION

Re: Sort Question

The PARM currently is: OPTION DYNSPC=1024,DYNALLOC=(SYSDA,59),FILSZ=E6000 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Vernooij, Kees (ITOPT1) - KLM Sent: Monday, October 02, 2017 9:47 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject:

Re: Sort Question

Vernooij, Kees (ITOPT1) - KLM > Sent: Monday, October 02, 2017 6:47 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Sort Question > > Apparently your sortwk's are that small, that many more are needed. > > Post your sortparameter, displayable with this job: > //LISTDE

Re: Sort Question

Apparently your sortwk's are that small, that many more are needed. Post your sortparameter, displayable with this job: //LISTDEF EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //SHOWDEF DD SYSOUT=* //TOOLIN DD *

Re: Sort Question

Development IBM Corporation IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 07/19/2017 09:40:11 AM: > From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 07/19/2017 09:40 AM > Subject: Re: Sort Qu

Re: Sort Question

On Wed, 19 Jul 2017 08:57:49 -0700, Sri h Kolusu wrote: >>> #$%& is indeed delimiter, any character set, anything which cannot be >found in real email address. > RFC 822 allows any displayable USASCII character if it's surrounded by quotation marks. But phsiii points out that so many sites

Re: Sort Question

Thank You Thanks, Kolusu IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 07/19/2017 06:37:33 AM: > From: "R.S." <r.skoru...@bremultibank.com.pl> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 07/19/2017 06:38 AM > Subject: Re: Sort Questi

Re: Sort Question

W dniu 2017-07-17 o 17:33, Sri h Kolusu pisze: I see the following room for improvement: 1. Do NOT limit domain field to first dot. Just take it as whole string. Example of sorted domains R.S My earlier job was just an untested sample that I wrote on the weekend to meet Edward's requirement.

Re: Sort Question

> On Jul 18, 2017, at 1:23 AM, Paul Gilmartin > <000433f07816-dmarc-requ...@listserv.ua.edu> wrote: > > How challenging were his data? In the easiest case, no "phrase" and > no quotation marks. > > — gil Gil: I will give him somewhat the benefit of the doubt the hardcopy I gave him

Re: Sort Question

On Mon, 17 Jul 2017 23:34:28 -0500, Edward Gould wrote: > >The user says he has about 20 million records. It is some sort of accumulated >history file. Don’t know any other details. >I gave him the IBM solution and told him to come back if he had any problems. >I was watching SDSF and a job poped

Re: Sort Question

U > Subject: Re: Sort Question > > > On Jul 15, 2017, at 3:43 PM, Lizette Koehler <stars...@mindspring.com> > wrote: > > > > Does this need to be a mainframe solution? > > > > How many records are involved? > > > > If not a lot of da

Re: Sort Question

> On Jul 15, 2017, at 3:43 PM, Lizette Koehler wrote: > > Does this need to be a mainframe solution? > > How many records are involved? > > If not a lot of data, I load this type of data to Excel. > > The using the DATA tab, I then highlight the column and use the

Re: Sort Question

On Mon, 17 Jul 2017 12:33:31 -0400, Tony Harminc wrote: > >... there is currently no other Tony in the email list at >this domain, so Tony is enough to reach me. That will surely change >one day, but what will the algorithm be? Reject, ignore, stick to the >existing rule and send to me...? >

Re: Sort Question

On 16 July 2017 at 10:28, Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> wrote: > (From RFC 822: > addr-spec = local-part "@" domain; global address ) ... > If the local-part contains special characters, it must be surrounded by > quotation marks. If there are no

Re: Sort Question

$ DOMAIN SORT FIELDS=(081,50,CH,A, $ NAME 131,50,CH,A),EQUALS $ DOMAIN /* Thanks, Kolusu DFSORT Development IBM Corporation From: "R.S." <r.skoru...@bremultibank.com.pl> To: IBM-MAI

Re: Sort Question

Thanks, Kolusu IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 07/16/2017 07:28:19 AM: From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> To: IBM-MAIN@LISTSERV.UA.EDU Date: 07/16/2017 07:28 AM Subject: Re: Sort Question Sent by: IBM Mainframe

Re: Sort Question

On Sun, 16 Jul 2017 07:38:36 -0700, Sri h Kolusu wrote: >>>... all challenges for DFSORT; some not algorithmically solvable. >' >Can you send me a sample of data with all the challenging scenarios and I >will *try* to see if I can solve it. For a fully tested solution it would >be only on

Re: Sort Question

t <IBM-MAIN@LISTSERV.UA.EDU> wrote on 07/16/2017 07:28:19 AM: > From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 07/16/2017 07:28 AM > Subject: Re: Sort Question > Sent by: IBM Mainframe Discussion List <IBM-M

Re: Sort Question

e needs to account for them which isn't that hard given that he had a template to start with. I just coded it on a saturday night with a sample data shown and it is an untested version. Thanks, Kolusu IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 07/16/2017 06:33:4

Re: Sort Question

On Sat, 15 Jul 2017 14:18:41 -0500, Edward Gould wrote: >One of my users asked me this question and I am not quite clear on how to >respond. >Given an email address aaa...@bbb.com (example) > >He just wants to sort on the field before the @ and then for a secondary sort

Re: Sort Question

On Sat, 15 Jul 2017 22:52:47 -0500, Edward Gould wrote: >> On Jul 15, 2017, at 10:39 PM, Sri h Kolusu wrote: >> >> Edward, >> >> Here is a DFSORT JCL which will give you the desired results. I assumed >> that your input file is FB and 80 bytes

Re: Sort Question

> -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Edward Gould > Sent: Saturday, July 15, 2017 8:53 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Sort Question > > > On Jul 15, 2017, at 10:39 PM, Sri h

Re: Sort Question

> On Jul 15, 2017, at 10:39 PM, Sri h Kolusu wrote: > > Edward, > > Here is a DFSORT JCL which will give you the desired results. I assumed > that your input file is FB and 80 bytes in length. I also assumed that > your name and domain names are each 30 bytes in length.

Re: Sort Question

Edward, Here is a DFSORT JCL which will give you the desired results. I assumed that your input file is FB and 80 bytes in length. I also assumed that your name and domain names are each 30 bytes in length. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * x...@bbb.com

Re: Sort Question

Look up the PARSE operand of the INREC and OUTREC control statements in the Application Programming Guide. > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Edward Gould > Sent: Saturday, July 15, 2017 12:19 PM > To:

Re: Sort Question

Does this need to be a mainframe solution? How many records are involved? If not a lot of data, I load this type of data to Excel. The using the DATA tab, I then highlight the column and use the TEXT TO COLUMS function to break on the @ Do my sorts, then put it back together (using CONCAT

Re: Sort Question

On Sat, 15 Jul 2017 14:18:41 -0500, Edward Gould wrote: >One of my users asked me this question and I am not quite clear on how to >respond. >Given an email address aaa...@bbb.com (example) > >He just wants to sort on the field before the @ and