Re: Calculate deltas using DFSORT

On Wed, 31 Aug 2022 16:35:27 +, Sri h Kolusu wrote: >... >>>The DFSORT manual (and others) should not attempt to explain regular >>>expressions. They should defer to citing a single publication with such an >>>explanation. > >I completely agree, however each component within IBM is

Re: Calculate deltas using DFSORT

On Wed, 31 Aug 2022 13:30:14 -0500, Walt Farrell wrote: > >But, whose "tradition"? PERL, PCRE, Python, Boost, ... > Don't overlook . -- gil -- For IBM-MAIN subscribe / signoff / archive

Re: Calculate deltas using DFSORT

On Wed, 31 Aug 2022 13:30:14 -0500, Walt Farrell wrote: > >>But it might be proper to emphasize any difference between DFSORT's use of >>reg-ex and traditional beliefs. > >But, whose "tradition"? PERL, PCRE, Python, Boost, ... > >Does the DFSORT documentation name a standard that they've

Re: Calculate deltas using DFSORT

On Wed, 31 Aug 2022 11:13:57 -0500, Paul Gilmartin wrote: >>In any case, "[^abc]" does not match "wombat". It matches only a single >>character of a string. So, it might match the "w" in "wombat", or the "o", or >>the "m", or the "t", depending on other details of the input string being

Re: Calculate deltas using DFSORT

On Wed, 31 Aug 2022 16:35:27 +, Sri h Kolusu wrote: >>>The DFSORT manual (and others) should not attempt to explain regular >>>expressions. They should defer to citing a single publication with such an >>>explanation. > >I completely agree, however each component within IBM is

Re: Calculate deltas using DFSORT

From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Tom Brennan [t...@tombrennansoftware.com] Sent: Wednesday, August 31, 2022 12:38 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Calculate deltas using DFSORT But with DFSORT I don't need to know the syntax at all. I can p

Re: Calculate deltas using DFSORT

...@listserv.ua.edu] Sent: Wednesday, August 31, 2022 11:03 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Calculate deltas using DFSORT On Wed, 31 Aug 2022 05:55:46 -0500, Mario Bezzi wrote: >Sri Hari, Max, all, > >thank you very much from your kind help and support. > >I really appreciate

Re: Calculate deltas using DFSORT

+1 Tom, in my experience getting tradition help here has been great, especially in the DFSORT area, in my experience getting help with Java related issues, even from my vendors was spurratic(sp)  at best Carmen On 8/31/2022 12:30 PM, Tom Brennan wrote: On 8/31/2022 9:35 AM, Sri h Kolusu

Re: Calculate deltas using DFSORT

On 8/31/2022 9:35 AM, Sri h Kolusu wrote: I can post a note here describing what I'm trying to do along with some data samples, and like the elves who make shoes, complete JCL and SYSIN will magically appear the next morning. Tom, I believe this platform is to share and help each other. I

Re: Calculate deltas using DFSORT

Hi, One email with multiple responses. >>. I can never understand what the DFSORT solutions are doing from reading the >>control cards, and I'm sure I am not alone there. A programming language >>makes it much easier for the person who has to understand it in the future. Andrew, Just to be

Re: Calculate deltas using DFSORT

(I forgot to ask whether the LOCALE command affects the interpretation of metacharacters in SYSIN. And to note that the Guide's using a proportional-spaced font makes syntax runes and examples confusing.) On Wed, 31 Aug 2022 10:21:42 -0500, Walt Farrell wrote: >On Wed, 31 Aug 2022 10:03:21

Re: Calculate deltas using DFSORT

On Wed, 31 Aug 2022 10:03:21 -0500, Paul Gilmartin wrote: > >"[^abc]" matches any string containing a character >other than a, b, or c. It matches "wombat". However, >"^[^abc]*$" matches strings containing no character >other than a, b, or c. It does not match "wombat". Was that something

Re: Calculate deltas using DFSORT

On Wed, 31 Aug 2022 05:55:46 -0500, Mario Bezzi wrote: >Sri Hari, Max, all, > >thank you very much from your kind help and support. > >I really appreciate it, and I hope to have the opportunity to reciprocate. > +1 Kolusu's assistance is priceless! I've read on about regular expressions. I

Re: Calculate deltas using DFSORT

Sri Hari, Max, all, thank you very much from your kind help and support. I really appreciate it, and I hope to have the opportunity to reciprocate. mario -- For IBM-MAIN subscribe / signoff / archive access instructions, send

Re: Calculate deltas using DFSORT

On 31/08/2022 10:02 am, Paul Gilmartin wrote: The DFSORT command syntax is dreadful -- too positional. It's hard to read ...,keyword,value,keyword,value,... Considerably better would be ,keyword(value), or ,keyword=value,... I'm not sure that it is that bad for defining a sort, but it does

Re: Calculate deltas using DFSORT

It's not meant to be disrespectful, and the only joke is the elves. The rest is reality as I see it. Whether that's good or bad I guess depends on your point of view. On 8/30/2022 10:19 PM, kekronbekron wrote: Although this is a joke... some respect for Sri please. Remember that he doesn't

Re: Calculate deltas using DFSORT

Although this is a joke... some respect for Sri please. Remember that he doesn't need to share anything. We'll be the ones looking dumb with capable tools & not knowing how to properly use them. - KB --- Original Message --- On Wednesday, August 31st, 2022 at 10:08 AM, Tom Brennan

Re: Calculate deltas using DFSORT

But with DFSORT I don't need to know the syntax at all. I can post a note here describing what I'm trying to do along with some data samples, and like the elves who make shoes, complete JCL and SYSIN will magically appear the next morning. On 8/30/2022 5:02 PM, Paul Gilmartin wrote: The

Re: Calculate deltas using DFSORT

On Wed, 31 Aug 2022 08:38:19 +1000, Andrew Rowley wrote: > >If we're looking at alternatives, there's also Java. I can never >understand what the DFSORT solutions are doing from reading the control >cards, ... > +1 The DFSORT command syntax is dreadful -- too positional. It's hard to read

Re: Calculate deltas using DFSORT

On 30/08/2022 10:46 pm, Bob Bridges wrote: I usually keep my bigoted mouth shut in threads like this, but guys, why DFSORT? That's great for the simple stuff, but REXX is so much easier and you don't have to sweat over more and more and yet more inventive solutions. If we're looking at

Re: Calculate deltas using DFSORT

On Tue, 30 Aug 2022 12:55:19 -0500, Paul Gilmartin wrote: > >... (Does DFSORT support regular expressions?) ... > Yes. I found it in the Ref. With several pages specifying regular expression syntax which would better be replaced by a citation of another document. -- gil

Re: Calculate deltas using DFSORT

On Tue, 30 Aug 2022 17:21:22 +, Sri h Kolusu wrote: > >≫ Little argument other than the economic balance between silicon and carbon, >counting learning in the latter. How much data? > >Take a simple of ca e less than or equal to 5 Million records. You can run a >test and see for your self

Re: Calculate deltas using DFSORT

≫ Little argument other than the economic balance between silicon and carbon, counting learning in the latter. How much data? Paul, Take a simple of case less than or equal to 5 Million records. You can run a test and see for your self as to how much it takes to do the same using REXX vs

Re: Calculate deltas using DFSORT

On Tue, 30 Aug 2022 16:28:24 +, Sri h Kolusu wrote: >>> I usually keep my bigoted mouth shut in threads like this, but guys, why >>> DFSORT? That's great for the simple stuff, but REXX is so much easier and >>> you don't have to sweat over more and more and yet more inventive solutions. >

Re: Calculate deltas using DFSORT

>> I usually keep my bigoted mouth shut in threads like this, but guys, why >> DFSORT? That's great for the simple stuff, but REXX is so much easier and >> you don't have to sweat over more and more and yet more inventive solutions. Bob, Rexx is a handy tool, but it performs poorly against

Re: Calculate deltas using DFSORT

Don’t have an answer, just a question. Do you need to allow for the quantity to go up? Say additional inventory was added and went from say, 20 to 40, which may result in a negative number during subtraction? On Tue, Aug 30, 2022 at 7:47 AM Bob Bridges wrote: > I usually keep my bigoted mouth

Re: Calculate deltas using DFSORT

Of Mario Bezzi Sent: Tuesday, August 30, 2022 12:32 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Calculate deltas using DFSORT Hello list, say I have a file with goods, dates, and available quantities, not necessarily sorted. I want to sort it and calculate daily deltas. For example using

Re: Calculate deltas using DFSORT

[robhbrid...@gmail.com] Sent: Tuesday, August 30, 2022 8:46 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Calculate deltas using DFSORT I usually keep my bigoted mouth shut in threads like this, but guys, why DFSORT? That's great for the simple stuff, but REXX is so much easier and you don't have

Re: Calculate deltas using DFSORT

I usually keep my bigoted mouth shut in threads like this, but guys, why DFSORT? That's great for the simple stuff, but REXX is so much easier and you don't have to sweat over more and more and yet more inventive solutions. --- Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313 /* It is a

Re: Calculate deltas using DFSORT

Mario, I first tried with WHEN=GROUP but with no success. After that I hopefully succeeded with a JOIN. The main idea is to extract keys from file and number those simply by sequential number. So the STAMPA "view" at ST010 should show something like this: SUGAR100 01 SUGAR97

Calculate deltas using DFSORT

Hello list, say I have a file with goods, dates, and available quantities, not necessarily sorted. I want to sort it and calculate daily deltas. For example using the following input : Product,Date,Availability Sugar,2022/08/01,100 Sugar,2022/08/02,97 Sugar,2022/08/03,93 I need to get to