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

Mainframe Discussion List On Behalf Of Farley, Peter x23353 Sent: Saturday, April 2, 2022 3:45 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [External] SORT question: Extract varying length string adding suffix after string? I have a use case to extract a varying length string where I need to add both

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

Sent: Saturday, April 2, 2022 3:45 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [External] SORT question: Extract varying length string adding suffix after string? I have a use case to extract a varying length string where I need to add both prefix and suffix constants to the selected string. The SORT

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

I have a use case to extract a varying length string where I need to add both prefix and suffix constants to the selected string. The SORT PARSE operand doesn't seem to do the trick because the FIXLEN parameter to PARSE is required and the selected strings will be blank-padded to the FIXLEN

Re: OMVS Sort Question

ion. Character is what you > are, reputation merely what others think you are.” - - - John Wooden > > -Original Message- > From: IBM Mainframe Discussion List On Behalf Of > Martin Packer > Sent: Thursday, September 9, 2021 6:51 AM > To: IBM-MAIN@LISTSERV.UA.EDU >

Re: OMVS Sort Question

hn Wooden -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri h Kolusu Sent: Thursday, September 9, 2021 8:47 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: OMVS Sort Question > What I would like to do is to sort the 2nd field in reverse and then > sort the 1st fie

Re: OMVS Sort Question

> What I would like to do is to sort the 2nd field in reverse and then sort > the 1st field in ascending - this does not seem possible. Lionel, You need to use the option "r" to perform the descending sort on the 2nd field. –r Reverses the order of all comparisons so that sort writes output

Re: OMVS Sort Question

rely what others think you are.” - - - John Wooden -Original Message- From: IBM Mainframe Discussion List On Behalf Of Patrick Hayward Sent: Thursday, September 9, 2021 8:39 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: OMVS Sort Question Can you not use -k2,2r Zlinux >From the man

Re: OMVS Sort Question

Can you not use -k2,2r Zlinux From the man page KEYDEF is F[.C][OPTS][,F[.C][OPTS]] for start and stop position, where F is a field number and C a character position in the field; both are origin 1, and the stop position defaults to the line's end. If neither -t nor -b is in effect,

Re: OMVS Sort Question

RV.UA.EDU Subject: Re: OMVS Sort Question Pipe it through two sort commands? And does sort helpfully avoid rearranging records with the same key value? Cheers, Martin Martin Packer WW z/OS Performance, Capacity and Architecture, IBM Technology Sales +44-7802-245-584 email: martin_pac...@uk.ibm.com

Re: OMVS Sort Question

e: 09/09/2021 12:25 Subject:[EXTERNAL] OMVS Sort Question Sent by:"IBM Mainframe Discussion List" I know how to use sort - to a limited degree. This will wort a stem using the 2nd field and sort in reverse: call bpxwunix 'sort -r -k 2',in.,out.,msg. What I would l

OMVS Sort Question

I know how to use sort - to a limited degree. This will wort a stem using the 2nd field and sort in reverse: call bpxwunix 'sort -r -k 2',in.,out.,msg. What I would like to do is to sort the 2nd field in reverse and then sort the 1st field in ascending - this does not seem possible. Any

Re: Batchpipes (was: SORT question: ...)

On Thu, 24 Sep 2020 10:47:37 -0500, Hobart Spitz wrote: >They find each other via the name of the pipe. > Is there an authority administering names of pipes, lest two users inadvertently choose the same one? Embedding in that name could resolve this. RACF? Even so: //SORTIN DD

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: Batchpipes (was: SORT question: ...)

annel/UCu_65HaYgksbF6Q8SQ4oOvA > > > > From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 23/09/2020 20:04 > Subject:[EXTERNAL] Batchpipes (was: SORT question: ...) > Sent by:IBM M

Re: Batchpipes (was: SORT question: ...)

04 Subject:[EXTERNAL] Batchpipes (was: SORT question: ...) Sent by:IBM Mainframe Discussion List On Wed, 23 Sep 2020 19:23:33 +0100, Martin Packer wrote: >No, that would have to be another job, also specifying eg SUBSYS=PIPE. And >scheduled to run alongside the sort

Batchpipes (was: SORT question: ...)

On Wed, 23 Sep 2020 19:23:33 +0100, Martin Packer wrote: >No, that would have to be another job, also specifying eg SUBSYS=PIPE. And >scheduled to run alongside the sort. > Eek! How do they find each other? And perhaps more important, what if several programmers unknown to each other

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

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

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

ubject: Re: Sort Question I see a couple things the DFSORT output The reason for the small mainsize and DSA=0 is because the program is passing MAINSIZE=00128000 ICE146I 0 END OF STATEMENTS FROM SORTCNTL - PARAMETER LIST STATEMENTS FOLLOW 
 SORT FIELDS=(0001,0013,CH,A) 
 RECORD TYP

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

UA.EDU] On > Behalf Of Pfister, Nathan > Sent: 02 October, 2017 15:40 > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Sort Question > > List; > > I have a question dealing with a DFSORT job which I am hoping to get > some guidance on. > > We have a COBOL program which inconsi

Sort Question

List; I have a question dealing with a DFSORT job which I am hoping to get some guidance on. We have a COBOL program which inconsistently gets a SORT CAPACITY EXCEEDED error. They've changed their cards several times with several different options to try and get this to work. Depending on

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

Sorting email addresses (was: Sort Question)

On 2017-07-17, at 05:58, R.S. wrote: > > 2. Uppercase and lowercase sorted in same order. ... > By Internet standard, the domain is case-insensitive. RFC 822 et al. leave interpretation of the local-part entirely to the target site, which is free to treat it as either case-sensitive or

Sorting email addresses (was: Sort Question)

(Subject: changed to be more relevant) On Sun, 16 Jul 2017 07:38:36 -0700, Sri h Kolusu wrote: > >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 Monday. > This page has a few more

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

: 07/15/2017 12:29 PM Subject: Sort Question Sent by:IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> 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 <mailto:aaa...@bbb.com> (examp

Re: Sort Question

t; To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Sort Question > > 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 <mailto:aaa...@bbb.com> (example) > > He just wants to sort on the field before the @ and

Re: Sort Question

function), or leave in excel for further filtering. Lizette > -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: IBM-MAIN@LISTSERV.UA.EDU > Subject: Sort Quest

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

Sort Question

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 the bbb field. Both fields are variable in length (not sure

Re: DF/SORT question (challenge?)

/2014 00:06 Subject:Re: DF/SORT question (challenge?) Sent by:IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU Try adding close=free to the DD statement Ed, When using DFSORT applications, FREE=CLOSE cannot be used on any DD statements except DFSPARM. Thanks, Kolusu IBM

Re: DF/SORT question (challenge?)

On Wed, 20 Aug 2014 19:21:00 -0500, Shane Ginnane wrote: awk '{print hlq.$1.file}' dfsort.input Even OMVS should be able to achieve that. Can't see any reason for a sort. Limit on number of open files? OP said hundreds or thousands. -- gil

Re: DF/SORT question (challenge?)

On Thu, Aug 21, 2014 at 7:35 AM, Paul Gilmartin 000433f07816-dmarc-requ...@listserv.ua.edu wrote: On Wed, 20 Aug 2014 19:21:00 -0500, Shane Ginnane wrote: awk '{print hlq.$1.file}' dfsort.input Even OMVS should be able to achieve that. Can't see any reason for a sort. Limit on

Re: DF/SORT question (challenge?)

On Thu, 21 Aug 2014 07:35:05 -0500, Paul Gilmartin wrote: Limit on number of open files? OP said hundreds or thousands. Rebuke accepted - maybe I can (now) see a need for a sort. Shane ... -- For IBM-MAIN subscribe / signoff

Re: DF/SORT question (challenge?)

In op.xkwasag27u3...@hawk01.hsd1.il.comcast.net, on 08/20/2014 at 09:34 AM, TonyIcloud-OPERA tonybabo...@icloud.com said: I have a dataset that contains records with a field, by which I need to create a separate dataset that would contain all occurrences of that field. ITYM a separate file

Re: DF/SORT question (challenge?)

On Thu, Aug 21, 2014 at 9:37 AM, Shmuel Metz (Seymour J.) shmuel+ibm-m...@patriot.net wrote: In op.xkwasag27u3...@hawk01.hsd1.il.comcast.net, on 08/20/2014 at 09:34 AM, TonyIcloud-OPERA tonybabo...@icloud.com said: I have a dataset that contains records with a field, by which I need to

Re: DF/SORT question (challenge?)

...@icloud.com To: IBM-MAIN@LISTSERV.UA.EDU Date: 08/20/2014 07:35 AM Subject: DF/SORT question (challenge?) Sent by: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU I have a dataset that contains records with a field, by which I need to create a separate dataset that would contain all occurrences

Re: DF/SORT question (challenge?)

-MAIN@LISTSERV.UA.EDU wrote on 08/20/2014 07:34:48 AM: From: TonyIcloud-OPERA tonybabo...@icloud.com To: IBM-MAIN@LISTSERV.UA.EDU Date: 08/20/2014 07:35 AM Subject: DF/SORT question (challenge?) Sent by: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU I have a dataset that contains

Re: DF/SORT question (challenge?)

] On Behalf Of TonyIcloud-OPERA Sent: Thursday, August 21, 2014 12:19 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DF/SORT question (challenge?) Before I tried the solution cited below (TYVM BTW), I set up a test manually with some interesting results. The input file is not sorted, and I'm only

Re: DF/SORT question (challenge?)

: TonyIcloud-OPERA tonybabo...@icloud.com To: IBM-MAIN@LISTSERV.UA.EDU Date: 08/21/2014 09:25 AM Subject: Re: DF/SORT question (challenge?) Sent by: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU Before I tried the solution cited below (TYVM BTW), I set up a test manually with some

Re: DF/SORT question (challenge?)

) http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ice1ca60/3.14 Thanks Kolusu DFSORT Development IBM Corporation From: TonyIcloud-OPERA tonybabo...@icloud.com To: IBM-MAIN@LISTSERV.UA.EDU Date: 08/21/2014 09:43 AM Subject:Re: DF/SORT question (challenge?) Sent

Re: DF/SORT question (challenge?)

IBM-MAIN@LISTSERV.UA.EDU wrote on 08/21/2014 09:28:51 AM: From: Hardee, Chuck chuck.har...@thermofisher.com To: IBM-MAIN@LISTSERV.UA.EDU Date: 08/21/2014 09:29 AM Subject: Re: DF/SORT question (challenge?) Sent by: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU Okay, let me say up

Re: DF/SORT question (challenge?)

In 0944307717662460.wa.paulgboulderaim@listserv.ua.edu, on 08/20/2014 at 12:13 PM, Paul Gilmartin 000433f07816-dmarc-requ...@listserv.ua.edu said: Strange DSN syntax, Have you checked the TRAILER3 keyword of OUTFIL in the DF/SORT documentation? -- Shmuel (Seymour J.) Metz,

DF/SORT question (challenge?)

I have a dataset that contains records with a field, by which I need to create a separate dataset that would contain all occurrences of that field. For example the file, FB100, looks like value1 other data. value1 other data. value1 other data. value2 other data. value2 other

Re: DF/SORT question (challenge?)

Have you considered writing a program which dynamically allocates the output files? On Wed, Aug 20, 2014 at 7:34 AM, TonyIcloud-OPERA tonybabo...@icloud.com wrote: I have a dataset that contains records with a field, by which I need to create a separate dataset that would contain all

  1   2   >