Re: Using JCL variables with DFSORT

On Thu, 3 Nov 2022 18:08:46 +, Jack Zukt wrote: >Hi Massimo, >Thank you for your input. >I have tried that approach, that I have used on other JCL without a glitch, >but it has not worked with this particular situation and I have not been >able to figure out why. > What do the JCL SUBSTITION

Re: Using JCL variables with DFSORT

Hi Massimo, Thank you for your input. I have tried that approach, that I have used on other JCL without a glitch, but it has not worked with this particular situation and I have not been able to figure out why. Regards Jack On Thu, Nov 3, 2022, 17:42 Massimo Biancucci wrote: > Jack, > > I

Re: Using JCL variables with DFSORT

Jack, I usually use JCLVAR this way (I think you need at least zOS 2.3 or 2.4): // EXPORT SYMLYST=* // SET EXTNUM=200 //ST010 EXEC PGM=SORT //SYSIN DD *,SYMBOLS=JCLONLY INCLUDE COND=(INP_EXTNTS,GT,) /* JES should change SYSIN before seeding SORT. Best regards. Max Il giorno gio 3 nov 2022

Using JCL variables with DFSORT

Hi, I am trying to improve a SORT by using a variable to specify a Include variable. I defined the variable by means of a //SET#EXTN SET EXTNUM=200 and then I used //STEP0100 EXEC PGM=SORT,PARM='JP1""' and INCLUDE=(INP_EXTNTS,GT,JP1), The problem, I think, is that the "200" is then used as

Re: DFSORT: Get part of a file between to records

AM Jack Zukt wrote: > > > > Hi, > > I am trying to use DFSORT to get part of a dataset. > > We are directing the output of an ABAR job to a dataset and I would like > to > > get the log for a specified date. Every LOG begins and ends with specific > > str

Re: DFSORT: Get part of a file between to records

Thanks Kolusu, It worked just as needed Best regards Jack On Tue, 11 Oct 2022 at 05:25, Sri h Kolusu wrote: > >> I am trying to use DFSORT to get part of a dataset. > > Jack, > > Please use the following untested JCL which will give you the desired > results >

Re: DFSORT: Get part of a file between to records

>> I am trying to use DFSORT to get part of a dataset. Jack, Please use the following untested JCL which will give you the desired results //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DISP=SHR,DSN=Your.input.FB.121.byte file //SORTOUT DD SYSOUT=* //SYSINDD * OPTIO

Re: DFSORT: Get part of a file between to records

IEBGENER RECORD statement? https://www.ibm.com/docs/en/zos/2.1.0?topic=statements-record-statement On Mon, Oct 10, 2022 at 10:17 AM Jack Zukt wrote: > > Hi, > I am trying to use DFSORT to get part of a dataset. > We are directing the output of an ABAR job to a dataset and I would l

DFSORT: Get part of a file between to records

Hi, I am trying to use DFSORT to get part of a dataset. We are directing the output of an ABAR job to a dataset and I would like to get the log for a specified date. Every LOG begins and ends with specific strings, and I would like to get those records and all the records in the middle, ignoring

Re: DFSORT / ICETOOL SPLICE function

Hi Sri, It works! Thank you so much! You made the statements very simple (eazy peazy). Any fool (just like me) can use it. The saving: 2.09 million input records REXX - 9 minutes clock time, 6 minutes CPU (IBM Z15 8561-723) DFSORT - 9 seconds clock time, 0.78 seconds CPU Unbelievable

Re: DFSORT / ICETOOL SPLICE function

I added now. OUTFIL REMOVECC,NODETAIL,BUILD=(80X), SECTIONS=(081,08, TRAILER3=(090,10,100,10,110,10)) Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instruction

Re: DFSORT / ICETOOL SPLICE function

Hi Sri This is great! Thank you! it's almost there. It only processes the 1st occurrence of "CURRENT PLAN OPERATION", and outputs 1 record correctly. There are many occurrences of "CURRENT PLAN OPERATION", and I need a record for each. Could you please help with the last bit? Kind regards,

Re: DFSORT / ICETOOL SPLICE function

BEGIN=(110,10,CH,GT,C' '), PUSH=(110:110,10)) OUTFIL INCLUDE=(081,08,ZD,EQ,1), REMOVECC,NODETAIL, SECTIONS=(081,08, TRAILER3=(090,10,100,10,110,10)) /* Thanks, Kolusu DFSORT Development IBM Corpo

Re: DFSORT / ICETOOL SPLICE function

Hi Max This was my miserable attempt (with various variations). Just keep getting the very 1st and very last record merged in both //SPLCE and //OUT1 datasets. * Top of Data **

Re: DFSORT / ICETOOL SPLICE function

Andreas, IFTHEN WHEN=GROUP is your best friend. I think Sri will give you the solution in a while. If he will not, at end of my workday I could try to provide a solution. Best regards. Max Il giorno ven 30 set 2022 alle ore 15:10 Andreas von Imhof <

DFSORT / ICETOOL SPLICE function

Hi I am trying to create 1 output record from multiple input records. Also the output record will be reformatted. I have been trying to get the ICETOOL SPLICE function to work, but alas to no avail. Please can someone help? Reason for wanting to use SORT/ICETOOL is to reduce CPU consumption

Re: Using DFSORT over DCOLLECT to get dataset extent number

Thank you Kolusu, I am going to try it, Best Regards, Jack On Wed, 28 Sept 2022 at 14:20, Sri h Kolusu wrote: > >> I am using OUTREC IFTHEN=(WHEN=( I have been reading the DFSORT > Application Programming Guide but I have not been finding what I need. As > far as I can tell,

Re: Using DFSORT over DCOLLECT to get dataset extent number

>> I am using OUTREC IFTHEN=(WHEN=( I have been reading the DFSORT Application >> Programming Guide but I have not been finding what I need. As far as I can >> tell, as soon as one of the IFTHEN=(WHEN is met, all the others are ignored. >> So, how do I test different pos

Re: Using DFSORT over DCOLLECT to get dataset extent number

Hi, I am trying to convert the DCOLLECT type "D" record fields DCDDSORG and DCDRECRD from its bits to a meaningful display (PS and VB, for instance). I am using OUTREC IFTHEN=(WHEN=( I have been reading the DFSORT Application Programming Guide but I have not been finding what I need. A

Re: Using DFSORT over DCOLLECT to get dataset extent number

> am using a SORT between the DCOLLECT and the rexx in order to have only the > type "D" records, I was wondering if it would be possible to process the > DCOLLECT output with DFSORT and get the same result. > My output file has this layout:: > +1+2+3

Using DFSORT over DCOLLECT to get dataset extent number

it would be possible to process the DCOLLECT output with DFSORT and get the same result. My output file has this layout:: +1+2+3+4+5+6+7+8+9+ Data Set NameOrg Alloc Used Perc% #Ex

Re: dfsort - microseconds (STCK/TOD)

Hi Kolusu, Now everything looks perfect and I share the relevant part of your solution happily: ... C'"TRNSTCK":"', 393,8,DC1,EDIT=(-TT-TT), C'T',

Re: dfsort - microseconds (STCK/TOD)

On Mon, 19 Sep 2022 19:23:36 +, Sri h Kolusu wrote: > >STCKE is only guaranteed to have UNIQUE within SYSPLEX. So, if the >transactions are across multiple sysplexs then you are not guaranteed to have >unique values. > For uniqueness µsec granularity is insufficient; TOD can return 4100

Re: dfsort - microseconds (STCK/TOD)

>> Ooooh! ISO 8601! Is that well supported by DFSORT? I don't see it >> mentioned in the Guide. Paul, DFSORT is NOT generating the time stamp in ISO8601 format. It is how OP is formatting the STCKE value with hard coded "T" for time and the UTC offset. Thanks, Kolusu

Re: dfsort - microseconds (STCK/TOD)

. How about comparing the HEX values of the contents in the INPUT file at position 393 for a length of 8 bytes? Can we eliminate that you do NOT have duplicated data in that position ? Do you have alternate method to compare the results? Thanks, Kolusu DFSORT Development IBM

Re: dfsort - microseconds (STCK/TOD)

On Mon, 19 Sep 2022 01:43:56 -0500, Stefan Lezzi wrote: >... >2022-09-12T13:55:27.836152+:00 >2022-09-12T13:55:27.836152+:00 >... Ooooh! ISO 8601! Is that well supported by DFSORT? I don't see it mentioned in the Guide. Of course for keys they're simply strings. <https:

Re: dfsort - microseconds (STCK/TOD)

Kolusu, Sorry, I thought it to be clear. This are IMS transactions timestamps, occurring every x seconds or so: ... 2022-09-12T13:55:27.836152+:00 2022-09-12T13:55:27.836152+:00 ... 2022-09-12T13:57:28.836152+:00 2022-09-12T13:57:29.836152+:00 2022-09-12T13:57:30.836152+:00

Re: dfsort - microseconds (STCK/TOD)

ecords and then we can verify if the value is converted correctly Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message

Re: dfsort - microseconds (STCK/TOD)

Hi Kolusu, Now I get this, which looks better, but seams still not to be correct: ... 2022-09-12T13:55:27.836152+:00 2022-09-12T13:55:27.836152+:00 ... 2022-09-12T13:57:28.836152+:00 2022-09-12T13:57:29.836152+:00 2022-09-12T13:57:30.836152+:00

Re: dfsort - microseconds (STCK/TOD)

517,8,DC1,EDIT=(-TT-TT),C'T', 517,8,TC4,EDIT=(TT:TT:TT.TT),C'+:00',C'",', C'"UOW":"',615,32,TRAN=HEX,C'",', C'}', 450:C'0',393,8,HEX)) OUTREC IFTHEN=(WHEN=(09,16

Re: dfsort - microseconds (STCK/TOD)

ETYPE":'), OVERLAY=(103:083,14,TRAN=UNHEX, 063:103,7,BI,+100,M11,LENGTH=6)) OUTFIL BUILD=(9,1100,SQZ=(SHIFT=LEFT)) PS : Also that is a very old techinque to compare files and match them. Look Up JOINKEYS and it can be done a Single pass of data Thanks, Kolusu DFSORT Devel

Re: dfsort - microseconds (STCK/TOD)

That's a kind offer, but please don't look at the (un)elegance of the code. This made a different thread :-) Just search for TRNSTCK and OVERLAY, at the end. //TOOLINDD * COPY FROM(IN)USING(CTL1) COPY FROM(OUT) TO(OUT2)

Re: dfsort - microseconds (STCK/TOD)

eir original positions. Use INREC BUILD to build all the fields you wanted and then use overlay on OUTREC to put the microseconds portion. If you can show me the complete cards, I probably can see what needs to be done. Thanks, Kolusu DFSORT Development IBM

Re: dfsort - microseconds (STCK/TOD)

I was prepared to be challenged by such questions :-) Anyway, for my purpose it's not yet so important (and a I can always "correct" the time in a splunk search). Anyway II, I suppose that, here again, I needed deep dfsort (lab) knowledge, if possible at all, to have CVTLSO a

Re: dfsort - microseconds (STCK/TOD)

e, subtract CVTLSO and add CVTLDTO to TOD. What do you want to happen if CVTLSO and/or CVTLDTO change between recording of the data and your DFSORT run? >And I know how to calculated an elapsed time in microseconds: > >C'"ELAMIC

Re: dfsort - microseconds (STCK/TOD)

Hi Kolusu, That's perfectly what I was looking for, many thanks! But to be honest, I don't get the math right (positions/offsets/length). I always end up with something like this: --+5+6+7+8+9+0+ 2022-09-12T13:55:27. 3871979727001140

Re: dfsort - microseconds (STCK/TOD)

>> I want to format a STCK/TOD with microseconds, but I found only the method >> to format it with hundredths of a second: Stefan, Here is a brief description of how to get the microseconds portion from TOD using DFSORT. Since you haven’t provided the complete DFSORT cards, I assum

Re: dfsort - microseconds (STCK/TOD)

t yourself with non-TOD-specific formatting instructions -- but I am not a DFSORT expert, not at all. I get why you want this. Hundredths are just not adequate in 2022. You need milliseconds at the very least, and microseconds would be nice. I suspect that if it is really, really important y

Re: dfsort - microseconds (STCK/TOD)

Thanks, I've just tested your suggestion: TT:TT:TT.TT -> 14:53:21.36 TT:TT:TT.TT -> 00:00:14.532136 It behaves like in the manual described: Format Code | Length | Description TC4 |8 bytes | TOD time interpreted as Z'hhmmssxx' and "The implied length of the edited

Re: dfsort - microseconds (STCK/TOD)

What happens if you change TT:TT:TT.TT to TT:TT:TT.TTT? Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Stefan Lezzi Sent: Friday, September 16, 2022 10:15 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: dfsort - microseconds

Re: dfsort - microseconds (STCK/TOD)

is "in the records of a file or SYSOUT." In that case I would think that a DFSORT-based approach makes sense. If the answers to both questions are "in memory inside an executing HLASM program" then STCKCONV makes sense. If the information is in files then STCKCONV implies writing a cu

Re: dfsort - microseconds (STCK/TOD)

Hi Tom, Yes, I know, if I would parse the IMS log records with assembler. But assembler is not my strongest skill, and, sadly, not very much loved by company management nowadays. It's about my, already coded and working, dfsort solution to parse some fields of the Mainview/IMS record x'FA

Re: dfsort - microseconds (STCK/TOD)

Better to use: https://www.ibm.com/docs/en/zos/2.1.0?topic=routine-description Tom Harper Phoenix Software International Sent from my iPhone > On Sep 16, 2022, at 12:28 PM, Stefan Lezzi > <04561630d35b-dmarc-requ...@listserv.ua.edu> wrote: > > Hi all! > > What do I miss? > > I want

dfsort - microseconds (STCK/TOD)

Hi all! What do I miss? I want to format a STCK/TOD with microseconds, but I found only the method to format it with hundredths of a second: C'"TRNSTCK":"',393,8,DC1,EDIT=(-TT-TT),C'T', 393,8,TC4,EDIT=(TT:TT:TT.TT),C'+00:00',C'",', And I know how to

Re: dfsort - Reformat file

dic > The EBCDIC is incomplete. It shows only 91 (my count), less than half the 256 possibilities. Conspicuously, it omits [, ], {, and }; integral to DFSORT. Those characters occur at different code points in the popular 037, 500, and 1047 code pages. I mentioned this concern in an RCF several days ago.

Re: dfsort - Reformat file

t OMIT and different relational operator (EQ , NE, GE,GT, LE, LT). So it is difficult to document every example and as is the DFSORT application programming guide is already 900 pages long. >> Is this the same Hexadecimal string format described above? No mention >> except

Re: [EXTERNAL] Re: dfsort - Reformat file

On Tue, 6 Sep 2022 21:32:37 +, Pommier, Rex wrote: > > >So each control statement must either be labelled or a comment, since it's >impossible not to use column 1 with RECFM=F. > > >No, because a bit earlier in the same manual, under the "general coding rules" >we find this: > >The control

Re: dfsort - Reformat file

what you meant by IMPOSSIBLE . You don’t have to always use column 1. You can leave blank lines in between control cards and DFSORT will simply ignore them and scan for the next available keyword. Here is an example. //SYSINDD * OPTION COPY SORT FIELDS=(1,3,CH,A) OUTREC OVERLAY=(3

Re: [EXTERNAL] Re: dfsort - Reformat file

statements). Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Paul Gilmartin Sent: Tuesday, September 6, 2022 3:44 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: dfsort - Reformat file On Tue, 6 Sep 2022 12:03:44 -0700, Tom Brennan wrote: >> >>

Re: dfsort - Reformat file

On Tue, 6 Sep 2022 12:03:44 -0700, Tom Brennan wrote: >> >> I just used a Special character to denote the start of a comment. You can >> have any character. > >And using # as that character shows we are being assimilated :) > Kolusu was just trying to make me comfortable. On Tue, 6 Sep 2022

Re: dfsort - Reformat file

On 9/6/2022 10:19 AM, Sri h Kolusu wrote: I just used a Special character to denote the start of a comment. You can have any character. And using # as that character shows we are being assimilated :) -- For IBM-MAIN

Re: [EXTERNAL] Re: dfsort - Reformat file

f Sri h Kolusu Sent: Tuesday, September 6, 2022 11:20 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: dfsort - Reformat file >> BTW, what's the syntax for comments in DFSORT command files? Gil, It is documented here https://urldefense.com/v3/__https://www.ibm.com/docs/en/zos/2

Re: dfsort - Reformat file

icult to have detailed comments as a part of >SYSIN control cards. > JES3 and later JES2 have removed the 80 byte limit many years ago. DFSORT would benefit from taking advantage of this. > ... The application programming guide explains in detail about the control > cards below. >Chec

Re: dfsort - Reformat file

etail about the control cards below. Check these links. https://www.ibm.com/docs/es/zos/2.5.0?topic=iriodse-example-1 https://www.ibm.com/docs/en/zos/2.5.0?topic=rrape-example-1 Thanks, Kolusu DFSORT Development IBM Corporation ---

Re: dfsort - Reformat file

On Tue, 6 Sep 2022 16:19:30 +, Sri h Kolusu wrote: > >It is documented here > >https://www.ibm.com/docs/en/zos/2.5.0?topic=rules-inserting-comment-statements > >>> The solution above, lacking comments and with 8 numeric positional >>> parameters is horribly opaque to the novice. > >If there

Re: dfsort - Reformat file

>> BTW, what's the syntax for comments in DFSORT command files? Gil, It is documented here https://www.ibm.com/docs/en/zos/2.5.0?topic=rules-inserting-comment-statements >> The solution above, lacking comments and with 8 numeric positional >> parameters is horribly op

Re: dfsort - Reformat file

/g' It's not what the oP asked for, but Mr. Natural says, Use the right tool for the job. BTW, what's the syntax for comments in DFSORT command files? The solution above, lacking comments and with 8 numeric positional parameters is horribly opaque to the novice. >-Original Message-

Re: dfsort - Reformat file

length of the data. So If you don't need the length part, then simply remove it using INREC or OUTREC as shown "retired mainframer" Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff

Re: dfsort - Reformat file

22,21,45,5) come close to what you want? -Original Message- From: IBM Mainframe Discussion List On Behalf Of Ron Thomas Sent: Monday, September 5, 2022 10:31 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: dfsort - Reformat file Hi , We have a input PIPE DELIMITED file as follows of lrecl

dfsort - Reformat file

Hi , We have a input PIPE DELIMITED file as follows of lrecl = 80. Need to remove the leading spaces with out disturbing the 3 column values 1652087|..0049|..OPTICAL |..0170| 2130994|..0006|..STATIONERY |..0716| 2199447|..0078|..SERVE OVER PIZZA|..0410|

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 agre

Re: DFSORT: BRE vs. ERE

On Fri, 2 Sep 2022 14:39:22 +, Sri h Kolusu wrote: >>> How can the programmer select which of the two supported versions DFSORT >>> will use? The later examples seem to show only EREs or to be neutral. An >>> example showing a BRE instead would be useful. >

Re: DFSORT: BRE vs. ERE

t; > How can the programmer select which of the two supported > versions DFSORT will use? The later examples seem to show > only EREs or to be neutral. An example showing a BRE > instead would be useful. > > Should I submit a RCF? > > -- > gil Try one with each se

Re: DFSORT: BRE vs. ERE

On Fri, 2 Sep 2022 14:39:22 +, Sri h Kolusu wrote: >>> How can the programmer select which of the two supported versions DFSORT >>> will use? > >Paul, > >Since both versions are supported, it is up to the programmer to use whichever >version fits his

Re: DFSORT: BRE vs. ERE

On Fri, 2 Sep 2022 07:33:27 -0500, Paul Gilmartin wrote: >In DFSORT Application Programming Guide: >INCLUDE Control Statement >Regular expressions >... >Two versions of regular expressions are supported: >• Basic Regular expressions (BRE) >• Extended Reg

Re: DFSORT: BRE vs. ERE

>> How can the programmer select which of the two supported versions DFSORT >> will use? The later examples seem to show only EREs or to be neutral. An >> example showing a BRE instead would be useful. Paul, Since both versions are supported, it is up to the programme

DFSORT: BRE vs. ERE

In DFSORT Application Programming Guide: INCLUDE Control Statement Regular expressions ... Two versions of regular expressions are supported: • Basic Regular expressions (BRE) • Extended Regular expressions (ERE) Regular expressions can be made up of normal characters

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 docum

Re: Calculate deltas using DFSORT

quot;m", or the "t", depending on other details of the input string being >>processed, and the application doing the processing. >> >Absent an anchor ("^" and/or "$") a pattern can be matched anywhere in a >subject. Good point. Thanks. > >>

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,

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

, but that shouldn't stop us from sharing the knowledge. I don't know how this turned into something about helping and sharing. I'm saying that if I don't know how to work either DFSORT or Java, I'd choose DFSORT because I'd get much better help here, often including complete and tested JCL/SYSIN

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 futu

Re: Calculate deltas using DFSORT

s not match "wombat". > >Was that something you said, or something you're quoting from the manual? I'm >not sure. > That;s what I said. The passage in z⧸OS DFSORT Application Programming Guide which I quoted and you trimmed was: Also, in a table: The caret symbol, when insid

Re: Calculate deltas using DFSORT

uot;, or the "o", or the "m", or the "t", depending on other details of the input string being processed, and the application doing the processing. I agree with your comment (which I omitted from my quote) that the DFSORT books should not

Re: Calculate deltas using DFSORT

ar expressions. I see in the DFSORT Guide: INCLUDE Control Statement The basic regular expression metacharacters are: ¬ $ . * \( \) [ \{ \} \ but later in a table: [^string] Is it "^" or "¬"? Some clarification is needed. I'll submit an RCF. I hate EBC

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

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 wrote: But with DFSORT I don't need to know the syntax at all. I can post a

Re: Calculate deltas using DFSORT

nnan wrote: > 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

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

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

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

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.

Re: Calculate deltas using DFSORT

see for your self as to how much it takes to do the same using REXX >vs DFSORT. > I wouldn't try to sort even a hundred records purely in REXX. It's the wrong tool for that. >>>... address LINKMVS DFSORT ... > >Aren't you invoking DFSORT from REXX? I think you ski

Re: Calculate deltas using DFSORT

DFSORT. >>... address LINKMVS DFSORT ... Aren't you invoking DFSORT from REXX? I think you skipped reading the text in BOLD " Moreover you need to have the Data SORTED before you can calculate the deltas and you need to invoke SORT or have a separate step to so

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 y

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 perfo

Re: Calculate deltas using DFSORT

uth 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 > > /

Re: Calculate deltas using DFSORT

/08/02,973 SUGAR,2022/08/03,934 X,2022/08/03,20 N/A Y,2022/08/01,150 N/A Y,2022/08/01,140 10 Further if you have any questions, please let me know Thanks, Kolusu DFSORT Development IBM Corporation -Original Message- From: IBM Mainframe Discussion List On Behalf

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

Re: Calculate deltas using DFSORT

08/01,N/A (No daily delta for the first record) > Sugar,2022/08/02,3 (100 - 97) > Sugar,2022/08/03,4(97 - 93) > > May I use bultin DFSORT functions to calculate deltas from the previous > record and the current one? > > I had a look at the OUTREC statement in the Applicat

Calculate deltas using DFSORT

to this: Product,Date,Sold Sugar,2022/08/01,N/A (No daily delta for the first record) Sugar,2022/08/02,3(100 - 97) Sugar,2022/08/03,4(97 - 93) May I use bultin DFSORT functions to calculate deltas from the previous record and the current one? I had a look at the OUTREC statement

Re: DFSORT INCLUDE COND - What am I doing wrong?

Thank you Max, Regards, Jack On Mon, 29 Aug 2022 at 16:31, Massimo Biancucci wrote: > Jack, > > I don't fully understand the output, the numbers at the beginnins seems to > be edit related and cols not. > This is my JCL, of course my catalog names are different but it doesn't > seem to matter.

Re: DFSORT INCLUDE COND - What am I doing wrong?

Jack, I don't fully understand the output, the numbers at the beginnins seems to be edit related and cols not. This is my JCL, of course my catalog names are different but it doesn't seem to matter. //ST010EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSINDD * DELETE

Re: DFSORT INCLUDE COND - What am I doing wrong?

Thank you Max, As suggested, =COLS> +1+2+3+4+5+6+7 08 IDC1566I ** .|. ...8..2...{. NOT LISTED 09 IDC3014I CATALOG ERROR 10 IDC3009I ** VSAM CATALOG RETURN CODE IS 50 - REASON CODE IS

<    1   2   3   4   5   6   7   8   9   10   >