Re: Calculate deltas using DFSORT

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 inclu

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

...@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

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

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, how

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

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

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

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 req

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? The later examples seem to show only EREs or to be neutral. An >>> example showing a BRE instead would be useful. >

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: 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 t

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

Re: dfsort - microseconds (STCK/TOD)

quot;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

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)

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 o

Re: dfsort - microseconds (STCK/TOD)

do it 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

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)

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 008B88

Re: dfsort - microseconds (STCK/TOD)

CVTLSO from TOD. If you want local time, 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

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 CVT

Re: dfsort - microseconds (STCK/TOD)

in their 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 Developmen

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) U

Re: dfsort - microseconds (STCK/TOD)

16,CH,EQ,C'{"MFSOURCETYPE":'), 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

Re: dfsort - microseconds (STCK/TOD)

C'"TRNLTERM":"',125,8,C'",', C'"TRNTCPU":"', 509,8,BI,DIV,+4096,EDIT=(.TT),C'",', C'"TRNSTCKE":"',

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 2022-09-12T13:57:59.836153+:0

Re: dfsort - microseconds (STCK/TOD)

d 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)

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 20

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.

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)

>> 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, Ko

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 dif

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', 393,8,TC1,

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 < 02ba5d449f94-dmarc-requ...@listserv.ua.edu

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 ** +1+2+3+4+5+

Re: DFSORT / ICETOOL SPLICE function

H=(100:100,10)), IFTHEN=(WHEN=GROUP, 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 Corporation

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, Andre

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

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"&EXTNUM"' and INCLUDE=(INP_EXTNTS,GT,JP1), The problem, I think, is that the "200" is then used as

Merging multiple records using DFSORT

I'm currently using this * Merge the LW file * * These sort commands can handle both the old, it's left unchanged, as * well as the new, records are merged, LW output file. *** OPTION COPY INREC IFTHEN=(WHEN=(1,1,CH,EQ,C'1',OR

DFSORT and SMF date selection

The brain is just not working today I guess. I want to use DFSORT to select some SMF records for a week; I'm getting myself confused in the DFSORT application programming guide Do I want to use INCLUDE COND=(11,4,PD,GE,&DATE3P-7) or INCLUDE COND=(11,4,Y4U,GE,&DATE3P-7) or

Re: DFSORT - compare two fields

he group. > I want to list all the record where owner is not groupname. > > So the goal is to compare two (fixed) fields and include/omit records. > Of course it can be done in REXX, but I think DFSORT is more efficient. > Any clue? >

Re: DFSORT - compare two fields

rd type 0203 - this is about user to group connection. There are fields: groupname and owner. Usually the owner is also the group. I want to list all the record where owner is not groupname. So the goal is to compare two (fixed) fields and include/omit records. Of course it can be done in REXX, but I

Re: DFSORT - AND/OR mystery

Try 5 pairs of conditions? INCLUDE COND=((5,4,CH,EQ,C'0205',AND,83,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,88,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,93,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,98,3,CH,EQ,C'YES'), OR

Re: DFSORT - AND/OR mystery

On Fri, 30 Jul 2021 09:54:51 -0500, Mike Schwab wrote: >Try 5 pairs of conditions? >INCLUDE COND=((5,4,CH,EQ,C'0205',AND,83,3,CH,EQ,C'YES'), > OR,(5,4,CH,EQ,C'0205',AND,88,3,CH,EQ,C'YES'), > OR,(5,4,CH,EQ,C'0205',AND,93,3,CH,EQ,C'YES'), > OR,(5,

Re: DFSORT - AND/OR mystery

tion AND is first. However parenthesis should change it and it is allow to use as many parenthesis as needed. 2. DFSORT should recognize the law (Rozdzielność działań in Polish) 3. I found another mystery, which seems to be APARable: The following statement gives several test records as e

Re: DFSORT - AND/OR mystery

N_GRP_OPER 98,3,CH,EQ,C'YES')),OR,$ USCON_REVOKE (05,4,CH,EQ,C'0102',AND,$ GPMEM_RECORD_TYPE 28,3,CH,NE,C'USE')) $ GPMEM_AUTH /* This should give produce the right results Ideally I would have used

Re: DFSORT - AND/OR mystery

ary to bracket the conjunctions in order that they have higher precedence than the alternations? Are you just rewriting Radoslaw's expression according to the Distributive Law? Does DFSORTT not recognize the Distributive Law? 1. Operator precedence. According to documentation AND is fir

Re: DFSORT - AND/OR mystery

erator precedence. https://www.ibm.com/docs/en/zos/2.3.0?topic=statement-relational-condition > Are you just rewriting Radoslaw's expression according to the Distributive Law? > Does DFSORTT not recognize the Distributive Law? There is NO need to code the statements the way that Mike h

Re: DFSORT - AND/OR mystery

gths have on the comparison tests. Use the control cards that I showed and if you are still NOT getting the right results, then please open a case with IBM support. IMHO you wouldn't need that, but just in case ! Thanks, Kolusu DFSORT Develo

Re: DFSORT - AND/OR mystery

W dniu 30.07.2021 o 19:35, Sri h Kolusu pisze: 3. I found another mystery, which seems to be APARable: But this statement gives zero records. Note, I added "OR" conditions, so it cannot narrow the output. Radoslaw, I would respectfully disagree with that statement. I explained the quirks of

Re: DFSORT - AND/OR mystery

ive Law? Does DFSORTT not recognize the Distributive Law? 1. Operator precedence. According to documentation AND is first. However parenthesis should change it and it is allow to use as many parenthesis as needed. 2. DFSORT should recognize the law (Rozdzielność działań in Polish) 3. I

Re: Line comments in DFSORT

>> I just did an experiment in DFSORT with JCL-style line comments after >> INCLUDE, SORT, and OUTREC, and they work! The DFSORT doc says that comments are only supported when entered with * on column 1. Bob, Of course, they work as you entered a REMARKS. Remark Field : Th

Re: Line comments in DFSORT

Thanks. That online doc is tricky, I read the detail page which didn't mention "Remarks". The higher level page that you shared did mention them. I experimented with our legacy system, and it supported them too (but was missing other features like OUTREC). Alas, ICETOOL does not support the sam

Re: Line comments in DFSORT

UT DD SYSOUT=* //TOOLIN DD * SORT FROM(IN) -# My comment in toolin USING(CTL1) /* //CTL1CNTL DD * SORT FIELDS=(1,3,CH,D) # sort field-1 Desc /* Thanks, Kolusu DFSORT Development IBM Corporation -- For IB

Re: Line comments in DFSORT

I was on bitsavers, so I looked.I thought I remembered that the old Sort/Merge program supported comments on the control cards. See pages 11 and 12. http://www.bitsavers.org/pdf/ibm/360/os/R01-08/C28-6543-2_Sort_Merge_Apr66.pdf I'm sure that DFSORT would have always accepted any valid

Re: Line comments in DFSORT

That is good news, but I cannot seem to replicate your results ICE281I 0 ORIGINAL OPERATOR STATEMENTS FOLLOW * Enter ICETOOL operators here * COPY FROM(INPUTA) TO(OUTA) # COPY INPUTA TO O

Re: Line comments in DFSORT

Add BOB to every record /* //ALAKCNTL DD * SORT FIELDS=(1,3,CH,D)# sort field-1 Desc /* Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, sen

Re: Line comments in DFSORT

e the DFSORT Application Programming Guide to verify that ICETOOL line comments are not documented. Thanks again for your help figuring this out. I'm updating our DFSORT and ICETOOL training course materials. The examples will be more readable now! Regards,

Re: Line comments in DFSORT

M(INPUTA) TO(OUTA) * COPY INPUT1 TO OUTB COPY FROM(INPUT1) TO(OUTB) USING(ALAS) * COPY INPUTX TO OUTC SORT FROM(INPUTX) TO(OUTC) USING(ALAK) /* >> I searched for every # in the the DFSORT Application Programming Guide to >> verify that ICETOOL line comments are not documented.

Re: Line comments in DFSORT

details of the code immediately to the left of it. This is the style I learned as an Assembler programmer, and it carries forward to my work in many other languages. DFSORT and ICETOOL code can be very complex, and is daunting for a new student, looking at it for the first time. While teachin

Re: Line comments in DFSORT

Subject: Re: Line comments in DFSORT I found this in the ICETOOL doc: | Continuation can be indicated by a hyphen (-) after the operator or after any operand. The next operand must then be specified on the next line. For example: | SORT FROM(INDD) - | USING(ABCD) - | TO(OUTPUT1,OUTPUT2,OUTPUT3

Re: Line comments in DFSORT

et what it is doing!" >> moments. Line comments help us to explain those gory details that lead to >> the "Light Bulb" moment. TOOLIN statements are mostly english like language statements and the gory details are in SYSIN and XXXCNTL and both of them al

Re: Line comments in DFSORT

OL operators here * My comment line - 1 * My comment line - 2 * My comment line - 3 * My comment line - 4 COPY FROM(INPUTA) TO(OUTA) /* Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signo

Re: Line comments in DFSORT

, 2024 10:22 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Line comments in DFSORT >> And, using the example provided, we are able to add a comment to the first >> two lines but not the last line, since it does not have a hyphen? Cameron, >> That is true. But if you want you can a

Re: DFSORT and IPL Date

Possibly a REXX process to capture/parse the output of a z/OS command /D IPLINFO. Scott Barry SBBTech LLC -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message

Re: DFSORT and IPL Date

Hi Scott, Thank you for the suggestion. I am trying to build the JCL using only DFSORT capabilities. I was just wondering if maybe that particular capability would be available, as DFSORT as a wide range of date processing. An may be that if not yet, it would become available in the near future

Re: DFSORT and IPL Date

< 059cd493dd41-dmarc-requ...@listserv.ua.edu> ha scritto: > Hi Scott, > Thank you for the suggestion. > I am trying to build the JCL using only DFSORT capabilities. I was just > wondering if maybe that particular capability would be available, as DFSORT > as a wide range o

Re: DFSORT and IPL Date

One option is to harvest the /D IPLINFO information at IPL-time (maybe using an automated-SUBMIT batch-job DFSORT / ICETOOL, or SAS, or REXX, etc.), parse and set a site-specific SYMBOL - then you can use it in one of various methods in a batch DFSORT job via an expected JCL INCLUDE MEMBER

Re: DFSORT and IPL Date

ime (maybe > using an automated-SUBMIT batch-job DFSORT / ICETOOL, or SAS, or REXX, > etc.), parse and set a site-specific SYMBOL - then you can use it in one of > various methods in a batch DFSORT job via an expected JCL INCLUDE > MEMBER=. Do consider challenges with symbol > naming

Re: DFSORT and IPL Date

>> Is there a way to make SORT date comparisons referencing the IPL date? I >> have not been able to find anything on the manual. Jack, DFSORT does not have direct access to IPL info. It can access system symbols but there is no system symbol defined for LAST IPL date (AFAIK).

Re: DFSORT and IPL Date

Okay, yes, these more-recent z/OS JCL days that's true - JCL SYMBOLs are now directly accessible in SYSIN DD *,SYMBOLS= -- but not indirectly when the SYSIN is not instream, so the JP"" method as a PARM= continues to be viable to bridge / pass symbolic data and have it be resolved within ICE

Re: DFSORT and IPL Date

rr date - 10 Regards Jack On Wed, 20 Mar 2024 at 15:36, Sri Hari Kolusu wrote: > > >> Is there a way to make SORT date comparisons referencing the IPL date? > I have not been able to find anything on the manual. > > Jack, > > DFSORT does not have direct access

Re: DFSORT and IPL Date

&DCOLINP //SORTOUT DD SYSOUT=* //SYSINDD * OPTION COPY INCLUDE COND=(DCURCTYP,EQ,DCUDATAT,AND, * Type = Data type DCDCREDT,LT,DATE3P-10,AND, * Created < curr date - 10 DCDCREDT,GE,IPLDATE) * Created >= IPLDATE /

Re: DFSORT and IPL Date

EADER) > // DD DISP=SHR,DSN=&DCOLSYM(TYPED) > // DD DISP=(OLD,DELETE),DSN=&&S > //SORTIN DD DISP=SHR,DSN=&DCOLINP > //SORTOUT DD SYSOUT=* > //SYSINDD * > OPTION COPY > INCLUDE COND=(DCURCTYP,EQ,DCUDA

Re: Regular Expressions: DFSORT, ISPF: "$","^"

compile and execute a regular expression . . .” We will have to wait for Sri Kolusu to answer for the DFSORT case. Peter From: IBM Mainframe Discussion List On Behalf Of Paul Gilmartin Sent: Saturday, April 20, 2024 10:47 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Regular Expressions: DFSORT

Re: Regular Expressions: DFSORT, ISPF: "$","^"

On Sat, 20 Apr 2024 19:41:49 +, Farley, Peter wrote: >For the ISPF case, I think the document writers think that they have covered >everything about the accepted regular expression syntax by stating up front on >that page: > >“ISPF uses the IBM® C regcomp() — Compile regular expression and r

Re: Regular Expressions: DFSORT, ISPF: "$","^"

Paul, DFSORT does indeed support "^" and "&" for the begin and end. https://www.ibm.com/docs/en/zos/2.4.0?topic=statement-regular-expressions If scroll down a bit in the above link, we do the examples. ^ibm Matches records beginning with "ibm" ibm$

Re: Regular Expressions: DFSORT, ISPF: "$","^"

On Sun, 21 Apr 2024 04:03:48 +, Sri Hari Kolusu wrote: >... >I know you are detail-attentive, so I would add it to the next pub refresh, >but it only goes into 3.1 (may be V2R5 but not sure). > >^ >The caret symbol matches the beginning the string. > >$ >The dollar symbol matches the end o

DFSort Report question - SYMNAMES DD ?

Can you set up a constant in the SYMNAMES DD to do that ? Or is that for different functions ? -Original Message- From: IBM Mainframe Discussion List On Behalf Of Lionel B. Dyck Sent: Monday, April 22, 2024 2:25 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: DFSort Report question Does

DFSORT - Something I can't see.

Hi everybody, I'm working on a dataset coming from LISTC LEV something ALL. I want to extract only a subset of records with the following SYSIN: //SYSINDD * *INCLUDE COND=(6,4,CH,EQ,C'DATA')COND #1 *INCLUDE COND=(71,7,CH,EQ,C'TRACKS-')COND #2 INCLUDE COND=(6,4,CH

Re: Using DFSORT to generate data

Is there any reason not to use IEBDG for this? Mark Jacobs Sent from ProtonMail mobile Original Message On Mar 27, 2019, 4:44 PM, Bill Ashton wrote: > Hi everyone! I am trying to generate a large test file for an internal > project, and I wanted to know if anyone has done this

Re: Using DFSORT to generate data

SEQNUM,10,PD,START=0, $ PACKED INCR BY 1 C'END OF THE GEN', $ STATIC TEXT 100:X) $ LRECL=100 //* Further if you have any questions please let me know Thanks, Kolusu D

Re: Using DFSORT to generate data

t; To: IBM-MAIN@LISTSERV.UA.EDU > Date: 03/27/2019 02:01 PM > Subject: Re: Using DFSORT to generate data > Sent by: IBM Mainframe Discussion List > > > Mark Jacobs > -- For IBM-MAIN subscribe / signoff / archiv

Re: Using DFSORT to generate data

Kolusu, you should write a Redbook. Or maybe better, a SHARE session: 101 things you didn't know that DFSORT could do. On Wed, Mar 27, 2019 at 6:31 PM Sri h Kolusu wrote: > > Is there any reason not to use IEBDG for this? > > Mark, > > Does IEBDG have the ability to g

Re: Using DFSORT to generate data

Truly. CharlesSent from a mobile; please excuse the brevity. Original message From: Steve Smith Date: 3/27/19 4:39 PM (GMT-08:00) To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Using DFSORT to generate data Kolusu, you should write a Redbook.  Or maybe better, a SHARE session

Re: Using DFSORT to generate data

On Wed, 27 Mar 2019 19:39:40 -0400, Steve Smith wrote: >Kolusu, you should write a Redbook. Or maybe better, a SHARE session: 101 >things you didn't know that DFSORT could do. > Wouldn't it be easier to enumerate just the things that DFSORT *can't* do? >On Wed, Ma

Re: Using DFSORT to generate data

Sri h Kolusu wrote: >It is quite easy to generate your test data. I generated 1 million records >with an LRECL of 100 bytes It is indeed easy for you. But for the rest of us, you're awesome with what you can conjure up with DFSORT and ICETOOL. > OUTFIL REPEAT=100, >

Re: Using DFSORT to generate data

I could not find a way for IEBDG to create the first record with 10001 in the first 9 bytes, then the next rec with 10009, then 10017, etc. In addition, I could not see any use of the time generation. I have used IEBDG only a few times in my life for simple things, so I am far from an e

Re: Using DFSORT to generate data

2 > C'STATIC TEXT - 02', $ STATIC TEXT > SEQNUM,10,PD,START=0, $ PACKED INCR BY 1 > C'END OF THE GEN', $ STATIC TEXT > 100:X) $ LRECL

Re: Using DFSORT to generate data

/03/2019 12:32 Subject:Re: Using DFSORT to generate data Sent by:IBM Mainframe Discussion List Kolusu, I would like one little tweak, if you please - is it possible to get the timestamp fresh on each record, instead of using the same timestamp value for all of them? Billy On Wed

Re: Using DFSORT to generate data

On Thu, 28 Mar 2019 13:21:40 +, Martin Packer wrote: >ON INREC, if you used IFTHEN WHEN=INIT you could prime with a timestamp >and then with a subsequent IFTHEN overwrite the last few bytes of the >timestamp with an incrementing value. > But what if the OP requires an actual timestamp rather

Re: Using DFSORT to generate data

You raise a good point but we don't know what kind of "real" timestamp they want. We could increment by, say, 1 second or 1 millisecond. Random increments is not something DFSORT can do. Cheers, Martin Martin Packer zChampion, Systems Investigator & Performance Troublesho

Re: Using DFSORT to generate data

m > increments is not something DFSORT can do. > > Cheers, Martin -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Using DFSORT to generate data

> Kolusu, I would like one little tweak, if you please - is it possible to > get the timestamp fresh on each record, instead of using the same timestamp > value for all of them? > Bill, Unfortunately DFSORT cannot get a fresh timestamp on each record. As far as I know even DB2 does

Re: Using DFSORT to generate data

On Thu, 28 Mar 2019 10:18:23 -0700, Sri h Kolusu wrote: >> Kolusu, I would like one little tweak, if you please - is it possible to >> get the timestamp fresh on each record, instead of using the same timestamp >> value for all of them? > >Bill, > >Unfortuna

<    3   4   5   6   7   8   9   10   11   12   >