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 imple

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 acce

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 implemente

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

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 implementin

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

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 it

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 wrote

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 fo

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 c

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

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 yo

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 se

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 get

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 n

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 wrot

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 DFS

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

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 alter

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 as

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 DF

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 hug

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

Mario, Max has the right idea but it is a overkill with 2 passes of data. Here is a simpler version with just 1 pass. Since the data is NOT sorted, I added a SORT statement. I assumed that the product has a length of 5 bytes and starts in position 1. I also added lot of comments so that it

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'

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 s

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 SUGAR97000