Re: DFSORT maximum input records

I imagine this wouldn't get you around the problem, but if you were sort the records in a separate DFSORT step, then feed the sorted data to your program, would it still complain about the number of records since it would encounter no need for any sorting at all? Just a thought. --

Re: DFSORT maximum input records

>> DFSORT issues a message that I have exceeded the sort input record maximum. Chuck, As Steve smith pointed out it Is your EQUALS parm that is limiting the number of records to be sorted. Do you really need EQUALS ( which is retain the order of duplicates). ? If you don't need

Re: DFSORT maximum input records

On 1/12/2023 9:37 AM, Radoslaw Skorupka wrote: Maximum input records for DFSORT is infinity, Good to know! I'm testing that to be sure, but it's still running... -- For IBM-MAIN subscribe / signoff / arch

Re: DFSORT maximum input records

s major efforts since it's a new product to us. > We were hoping for some other DFSORT option to at least let us move > forward. > > Thanks everyone for listening and your replies. > Chuck > > On Thu, Jan 12, 2023 at 12:21 PM rpinion865 < > 042a019916dd-dmarc-requ...@

Re: DFSORT maximum input records

mitation, it must be using a bigger sequence field. Maybe you could ask IBM to allow for that. sas On Thu, Jan 12, 2023 at 1:02 PM Charles Hardee wrote: > I have plenty of SORTWKxx DDs. > I don't think that is the problem. > > I am getting an IEX121A message. > According to

Re: DFSORT maximum input records

I have run into large files with DFSORT, and when I asked them they told me that there are hard limits: * EQUALS in effect - 4 294 967 295 records * VLSHRT in effect - 2 147 483 647 records * Blockset technique not selected - 2 147 483 647 records I wonder if you could do something in your

Re: DFSORT maximum input records

Yes, we've been informed that SYNCSORt doesn't have this limitation but getting it in-house takes major efforts since it's a new product to us. We were hoping for some other DFSORT option to at least let us move forward. Thanks everyone for listening and your replies. Chuck On Th

Re: DFSORT maximum input records

have plenty of SORTWKxx DDs. > I don't think that is the problem. > > I am getting an IEX121A message. > According to the DFSORT Messages, Codes and Diagnosis Guide for z/OS 2.5: > > ICE121A FILE SIZE IS TOO LARGE > Explanation > Critical. The amount of data to b

Re: DFSORT maximum input records

I have plenty of SORTWKxx DDs. I don't think that is the problem. I am getting an IEX121A message. According to the DFSORT Messages, Codes and Diagnosis Guide for z/OS 2.5: ICE121A FILE SIZE IS TOO LARGE Explanation Critical. The amount of data to be sorted exceeded a DFSORT implementation

Re: DFSORT maximum input records

On Thu, 12 Jan 2023 10:42:51 -0600 Charles Hardee wrote: :>I've searched the IBM-MAIN archives and found nothing to help me so I :>thought I'd better ask the question. :>I am trying to sort roughly 4295217295, records using DFSORT. :>DFSORT issues a message that I have e

Re: DFSORT maximum input records

Maximum input records for DFSORT is infinity, *except* some options like EQUALS. For EQUALS the maximum is 4Gi records (means 2**32). Sometimes it is good idea to change SORT to MERGE. -- Radoslaw Skorupka Lodz, Poland -Original Message- From: IBM Mainframe Discussion List On

Re: DFSORT maximum input records

Apologies for the typo, the Syncsort option is DYNALLOC, not DYNALOC. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Farley, Peter Sent: Thursday, January 12, 2023 12:12 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT maximum input records Not sure if DFSORT

Re: DFSORT maximum input records

Not sure if DFSORT has an equivalent option, but Syncsort has a parameter DYNALOC that can change the maximum number of SORTWKnn DD's it will allocate. Our local Syncsort default is 64, but for really big sorts (when we get the Syncsort equivalent "too big to sort" message, w

DFSORT maximum input records

Hello Listers, I've searched the IBM-MAIN archives and found nothing to help me so I thought I'd better ask the question. I am trying to sort roughly 4295217295, records using DFSORT. DFSORT issues a message that I have exceeded the sort input record maximum. It appears that this

Re: Problem with DFSORT SUM FIELDS

changed the SYMNAMES to add the > temp fields. > > // DD * > SKIP,2 > TMP-DCVVLCAP,*,8,BI > TMP-DCVVLCAP1,=,4,BI > TMP-DCVVLCAP2,*,4,BI > TMP-DCVALLOC,*,8,BI > TMP-DCVALLOC1,=,4,BI > TMP-DCVALLOC2,*,4,B

Re: Problem with DFSORT SUM FIELDS

MBOL, SYNTAX OR DELIMITER ERROR ICE287A 0 ONE OR MORE ERRORS ENCOUNTERED DURING SYMBOL SUBSTITUTION ICE751I 0 C5-I90068 E7-I76949 ICE052I 3 END OF DFSORT As I said in in my previous email, the "$" sing is bellow de "D" after the ":", and that baffles me because that

Re: Problem with DFSORT SUM FIELDS

*,4,BI Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Problem with DFSORT SUM FIELDS

1,4, > DCVSGTCL, >X, >TMP-DCVVLCAP,TO=ZD,LENGTH=16, >X, >TMP-DCVALLOC,TO=ZD,LENGTH=16) > /* > > > Thanks, > Kolusu > DFSORT Development > IBM Corporat

Re: Problem with DFSORT SUM FIELDS

TMP-DCVALLOC) OUTREC BUILD=(1,4, DCVSGTCL, X, TMP-DCVVLCAP,TO=ZD,LENGTH=16, X, TMP-DCVALLOC,TO=ZD,LENGTH=16) /* Thanks, Kolusu DFSORT Dev

Problem with DFSORT SUM FIELDS

Hi, I am trying to use DFSORT to summarize the space on a few STORAGE GROUPS. The INPUT is a file with all the DCOLLECT TYPE "V" records. I am sorting it by the storage group name, and using for SUM FIELDS the "TOTAL CAPACITY OF VOL" and "ALLOCATED SPACE ON VOL"

Re: DFSORT: Building one record from two and ignore the rest

END=(02,05,CH,EQ,C'OHSM.'), > PUSH=(81:11,44)) > > OUTFIL INCLUDE=(02,05,CH,EQ,C'OHSM.'), >BUILD=(81,44, # DSNAME > 2X,

Re: DFSORT: Building one record from two and ignore the rest

,EQ,C'DSNAME ='), END=(02,05,CH,EQ,C'OHSM.'), PUSH=(81:11,44)) OUTFIL INCLUDE=(02,05,CH,EQ,C'OHSM.'), BUILD=(81,44, # DSNAME 2X, # 2 SPACES

Re: DFSORT: Building one record from two and ignore the rest

=(WHEN=(02,08,CH,EQ,C'DSNAME ='), >BUILD=(11,44)), > IFTHEN=(WHEN=(02,05,CH,EQ,C'OHSM.'), >BUILD=(02,51)) > /* > > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > >

Re: DFSORT: Building one record from two and ignore the rest

IFTHEN=(WHEN=(02,05,CH,EQ,C'OHSM.'), BUILD=(02,51)) /* Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

DFSORT: Building one record from two and ignore the rest

Hi, I have a file that was built by a HSM command and that has a few thousand groups of records such as this: +1+2+3+4+5+6+7+8+9+0+1+2- 1- DFSMSHSM CONTROL DATASET - BACKUP DATASET-- LISTING - AT 10:

Re: Using JCL variables with DFSORT

Jack, as you can see, lots of people try to help. If you want them to better help, include jobs output or similar. Best regards. Max Il giorno ven 4 nov 2022 alle ore 14:58 Sri h Kolusu ha scritto: > >> Is there any conversion function like Rexx C2D()? > Gil, > > As mention

Re: Using JCL variables with DFSORT

>> Is there any conversion function like Rexx C2D()? Gil, As mentioned earlier, DFSORT gives you the flexibility of converting the passed symbol to any numeric format (Binary, Packed, Floating point..) Assuming the LRECL=200 for the input file , you can use the following INREC OVERLAY=(2

Re: Using JCL variables with DFSORT

to it which coerced it to numeric format. Would something similar work in DFSORT? Is there any conversion function like Rexx C2D()? -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists

Re: Using JCL variables with DFSORT

caveat is you need to have SYSSYM=ALLOW for the jobclass your job is running. Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists

Re: Using JCL variables with DFSORT

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 Biancu

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 usuall

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,&EXTNUM) /* JES should change SYSIN before seeding SORT. Best regards. Max Il giorno gio 3 nov

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

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

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

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

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

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

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

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

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

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)

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

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

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)

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)

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)

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

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)

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)

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)

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)

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)

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)

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

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)

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)

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)

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)

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)

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

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 calcu

Re: dfsort - Reformat file

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

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

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 s

Re: dfsort - Reformat file

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

Re: [EXTERNAL] Re: dfsort - Reformat file

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

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 subscri

Re: [EXTERNAL] Re: dfsort - Reformat file

alf Of 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/doc

Re: dfsort - Reformat file

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

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

fields s/| */|/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 novic

Re: dfsort - Reformat file

e 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

Re: dfsort - Reformat file

(5,8,15,5,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

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

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 req

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 or

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

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

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