Re: DFSORT newline

2024-05-12 Thread Paul Gilmartin
On Sun, 12 May 2024 12:20:09 +, Sri Hari Kolusu wrote: >... >As Mike mentioned, Data on z/OS data is governed by the LRECL. So, there is >no newline character. If you are planning to parse out transferred binary >data, then depending on where the file originated, you can use the

Re: DFSORT newline

2024-05-12 Thread Sri Hari Kolusu
>> So how may the programmer match a newline character? Paul, As Mike mentioned, Data on z/OS data is governed by the LRECL. So, there is no newline character. If you are planning to parse out transferred binary data, then depending on where the file originated, you can use the equivalent Hex

Re: DFSORT newline

2024-05-11 Thread Seymour J Metz
equ...@listserv.ua.edu> Sent: Saturday, May 11, 2024 9:25 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: DFSORT newline in <https://www.ibm.com/docs/en/zos/3.1.0?topic=statement-regular-expressions>, I read: . The period symbol matches any one character except the terminal newline character.

Re: DFSORT newline

2024-05-11 Thread Mike Schwab
w may the programmer match a newline character? > I I read in an apparently related publication, > <https://www.ibm.com/docs/en/zos/3.1.0?topic=functions-regcomp-compile-regular-expression>, > $ > The dollar symbol matches the end of the string. (Use \n to match a > newline

DFSORT newline

2024-05-11 Thread Paul Gilmartin
<https://www.ibm.com/docs/en/zos/3.1.0?topic=functions-regcomp-compile-regular-expression>, $ The dollar symbol matches the end of the string. (Use \n to match a newline character.) Does "\n" work alike for DFSORT? What is the code point for the newline character? It doesn't appea

Re: DFSORT Guide feedback?

2024-05-04 Thread Paul Gilmartin
On Sat, 4 May 2024 18:52:19 +, Sri Hari Kolusu wrote: > >Also, in the PDF documentation it is divided as chapters and the web >documentation does not have that, but it is in the same chapter order as the >PDF. So here is the link to DFSORT Application Programming Gu

Re: DFSORT Guide feedback?

2024-05-04 Thread Sri Hari Kolusu
tation does not have that, but it is in the same chapter order as the PDF. So here is the link to DFSORT Application Programming Guide https://www.ibm.com/docs/en/zos/3.1.0?topic=guide-abstract-dfsort-application-programming Now see the left panel which shows the subtopics within this book, and y

Re: DFSORT Guide feedback?

2024-05-04 Thread Paul Gilmartin
find web page"? > >The table 109 you refer is referring to the EBCDIC table listed here. > >https://www.ibm.com/docs/en/zos/3.1.0?topic=sequences-ebcdic > Excellent; thanks! How did you find that? I tried to no avail with Google keywords: site:IBM.com dfsort ebcdic coll

Re: DFSORT Guide feedback?

2024-05-04 Thread Sri Hari Kolusu
C table listed here. https://www.ibm.com/docs/en/zos/3.1.0?topic=sequences-ebcdic Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email

DFSORT Guide feedback?

2024-05-04 Thread Paul Gilmartin
I wabt to provide feedback on: DFSORT Application Programming Guide SC23-6878-60 Table 109 EBCDIC ... In that publication I read: How to provide feedback to IBM We welcome any feedback that you have, including comments on the clarity, accuracy, or completeness of the information

Re: DFSort Report question

2024-04-22 Thread Sri Hari Kolusu
NOPHRASE D LIONEL Hope that is what you want. PS: if you don't have COPY/SORT pass before the DISPLAY , then you can do it using traditional reporting features. Thanks, Kolusu DFSORT Development IBM C

Re: DFSort Report question

2024-04-22 Thread Lionel B. Dyck
Behalf Of Sri Hari Kolusu Sent: Monday, April 22, 2024 2:02 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSort Report question >> The ON value could be "LEGACY", "KDFAES", "PASSWORD" or "NOPHRASE". Lionel, How do you determine which header value need

Re: DFSort Report question

2024-04-22 Thread Sri Hari Kolusu
>> The ON value could be "LEGACY", "KDFAES", "PASSWORD" or "NOPHRASE". Lionel, How do you determine which header value need to be used? I am guessing that it is going to depend on a value in the file. If So we can dynamically change it. Tha

DFSort Report question - SYMNAMES DD ?

2024-04-22 Thread Nash, Jonathan S.
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 Report question

2024-04-22 Thread Lionel B. Dyck
Does anyone know who to change the value found in the ON to a more meaningful value: For example this: HEADER('PassPhrase') ON(616,10,CH) The ON value could be "LEGACY", "KDFAES", "PASSWORD" or "NOPHRASE". Thanks in advance Lionel B. Dyck <>< Github: https://github.com/lbdyck System Z

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

2024-04-20 Thread Paul Gilmartin
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

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

2024-04-20 Thread Sri Hari Kolusu
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: "$","^"

2024-04-20 Thread Paul Gilmartin
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

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

2024-04-20 Thread Farley, Peter
to 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

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

2024-04-20 Thread Paul Gilmartin
The description of regular expressions for DFSORT: <https://www.ibm.com/docs/en/zos/3.1.0?topic=statement-regular-expressions> mentions "$" to match the end of a string, but not "^" to match the beginning. The description of regular expressions for ISPF: <https://

Re: DFSORT SUBDAYS function

2024-04-09 Thread rpinion865
> > > use the SUBDAYS function. I am looking at the DFSORT Programmer Guide. > > > But I learn best by example. > > > Richard, > > Your input date has separators and DFSORT date arithmetic functions works on > date without separators. So, we just need to strip off

Re: DFSORT SUBDAYS function

2024-04-09 Thread Sri Hari Kolusu
>> The date begins in column 1 and is 10 characters long. I know I want to use >> the SUBDAYS function. I am looking at the DFSORT Programmer Guide. But I >> learn best by example. Richard, Your input date has separators and DFSORT date arithmetic functions works on date

DFSORT SUBDAYS function

2024-04-09 Thread rpinion865
I have the following field in a dataset, that I want to subtract days from, leaving the date in the original format. The date begins in column 1 and is 10 characters long. I know I want to use the SUBDAYS function. I am looking at the DFSORT Programmer Guide. But I learn best by example. 2024

Re: DFsort error message

2024-03-28 Thread Lennie Bradshaw
-Bradshaw https: //rsclweb.com -Original Message- From: IBM Mainframe Discussion List On Behalf Of Bob T Roller Sent: 27 March 2024 17:04 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFsort error message One of the most important things I learned 45 years ago was 37 is always a space issue

Re: DFsort error message

2024-03-27 Thread Bob T Roller
: BELOW 16M = 20480, ABOVE 16M = 2119680 > ICE855I 0 SORTOUT : TX=N, R=J, L=J, B=D, BL=0, BR=0, DCT=37, VS=N, RU=X, SB=8 > ICE210I 0 SORTOUT : EXCP USED, LRECL = 317, BLKSIZE = 27896, TYPE = FB > ICE751I 2 EF-I80638 CB-NONE F0-NONE DA-I76950 > ICE185A 0 AN SE37 ABEND WAS ISSUED BY DFSORT, ANOT

Re: DFsort error message

2024-03-26 Thread Lizette Koehler
Message- From: IBM Mainframe Discussion List On Behalf Of Sri Hari Kolusu Sent: Tuesday, March 26, 2024 11:47 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFsort error message >> Is this a standalone sort or one from a cobol program or db2 process? Lizette, It is a JCL invoked SORT.

Re: DFsort error message

2024-03-26 Thread Sri Hari Kolusu
>> Is this a standalone sort or one from a cobol program or db2 process? Lizette, It is a JCL invoked SORT. Clue : ICEAM1 INVOCATION ENVIRONMENT IN EFFECT - ICEAM1 ENVIRONMENT SELECTED Thanks, Kolusu DFSORT Development IBM Corpo

Re: DFsort error message

2024-03-26 Thread Lizette Koehler
Sort received an SE37: ICE185A 0 AN SE37 ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHASE So the dataset was probably allocated on a volume without sufficient space to expand or ran out of extents Is this a standalone sort or one from a cobol program or db2 process? Regards

Re: DFsort error message

2024-03-26 Thread Sri Hari Kolusu
>> ICE185A 0 AN SE37 ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT >> (PHASE Ron, Most likely your job abended due to lack of space on SORTOUT dataset. Check the JESMSGLG for a detailed explanation of the E37 abend also the dataset name. Fix the space on the dataset by

Re: DFsort error message

2024-03-26 Thread Steely.Mark
List On Behalf Of Ron Thomas Sent: Tuesday, March 26, 2024 12:24 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: DFsort error message CAUTION! EXTERNAL SENDER! STOP, ASSESS, AND VERIFY Do you know this person? Were you expecting this email? If not, report it using the Report Phishing Button! Hi All

DFsort error message

2024-03-26 Thread Ron Thomas
-NONE DA-I76950 ICE185A 0 AN SE37 ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHASE Job Step work file details . Allocated SORTWK50 files XXSORTWK09 DD DISP=(NEW,DELETE,DELETE),SPACE=(CYL,()) IEFC653I SUBSTITUTION JCL - DISP=(NEW,DELETE,DELETE),SPACE=(CYL,(200)) XXSORTWK10 DD DISP

Re: DFSORT and IPL Date

2024-03-21 Thread Jack Zukt
> //SORTIN DD DISP=SHR,DSN= > //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) * Creat

Re: DFSORT and IPL Date

2024-03-20 Thread Sri Hari Kolusu
,DCUDATAT,AND, * Type = Data type DCDCREDT,LT,DATE3P-10,AND, * Created < curr date - 10 DCDCREDT,GE,IPLDATE) * Created >= IPLDATE /* Further if you have any questions, please let me know Thanks, K

Re: DFSORT and IPL Date

2024-03-20 Thread Jack Zukt
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

2024-03-20 Thread Scott Barry
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

Re: DFSORT and IPL Date

2024-03-20 Thread Sri Hari Kolusu
>> 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

2024-03-20 Thread Jack Zukt
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

2024-03-20 Thread Scott Barry
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

2024-03-20 Thread Massimo Biancucci
< 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 ran

Re: DFSORT and IPL Date

2024-03-20 Thread Jack Zukt
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

2024-03-20 Thread Scott Barry
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

DFSORT and IPL Date

2024-03-20 Thread Jack Zukt
Hi, Is there a way to make SORT date comparisons referencing the IPL date? I have not been able to find anything on the manual. Regards Jack -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

Re: Line comments in DFSORT

2024-03-08 Thread Cameron Conacher
, 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: Line comments in DFSORT

2024-03-08 Thread Sri Hari Kolusu
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-03-08 Thread Sri Hari Kolusu
, I get 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

2024-03-08 Thread Cameron Conacher
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

2024-03-08 Thread Bob Stark
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 teach

Re: Line comments in DFSORT

2024-03-07 Thread Sri Hari Kolusu
UTA) 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. N

Re: Line comments in DFSORT

2024-03-07 Thread Bob Stark
# in the 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, Bob Stark

Re: Line comments in DFSORT

2024-03-07 Thread Sri Hari Kolusu
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, send email to

Re: Line comments in DFSORT

2024-03-07 Thread Bob Stark
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

Re: Line comments in DFSORT

2024-03-07 Thread Tom Marchant
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 Sort

Re: [EXTERNAL] Line comments in DFSORT

2024-03-07 Thread Pommier, Rex
Sorry, I didn't see Sri's remarks (no pun intended) until after I had replied. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex Sent: Thursday, March 7, 2024 3:59 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: [EXTERNAL] Line comments in DFSORT Actually

Re: [EXTERNAL] Line comments in DFSORT

2024-03-07 Thread Pommier, Rex
Actually it is documented. They're just not called comments. Look up "remark" in the DFSort application programming guide. Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Bob Stark Sent: Thursday, March 7, 2024 2:03 PM To: IBM-MAIN@LISTSERV.UA.E

Re: Line comments in DFSORT

2024-03-07 Thread Sri Hari Kolusu
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

2024-03-07 Thread Bob Stark
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

Re: Line comments in DFSORT

2024-03-07 Thread Sri Hari Kolusu
>> 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

Line comments in DFSORT

2024-03-07 Thread Bob Stark
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. When was this implemented, and why isn’t this documented? Do you think it is safe to rely

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Cameron Conacher
Code value, I could use to conditionally execute a JOBSTEP. Thanks …….Cameron From: IBM Mainframe Discussion List On Behalf Of Michael Oujesky Sent: Monday, March 4, 2024 12:38 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Can DFSORT assign custom Return Code values? Presuming these are three

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Binyamin Dissen
s is not possible, but I decided to throw it out there to see if something is possible. :> :>I have a block of JCL with a bunch of steps. :>I have symbolic parameters assigned. (JP1/JP2 SYSPLEX Symbolics for DFSORT) :> :>I was looking for a Utility that would examine the value of a Sy

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Sri Hari Kolusu
>> Another simple way to do this is a simple Rexx exec using MVSVAR to get the >> system symbol that you want . See >> https://www.ibm.com/docs/en/zos/2.5.0?topic=tef-mvsvar to see examples of >> how to do this. Doug, As I mentioned earlier you don't need REXX to get t

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Michael Oujesky
Return Code values (any value) that I can let check to determine if I am running in Development, Pre-Prod or Production, and then execute steps related to the specific environment. Not something I absolutely need since I could write a tiny program for this. Cameron, DFSORT has limited ability

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Robert Prins
On Mon, 4 Mar 2024 at 16:13, Sri Hari Kolusu wrote: > Please send an offline email with your complete requirement and I will > show you a way to do it. > After all, why would anyone else be interested in it? Robert -- Robert AH Prins robert(a)prino(d)org The hitchhiking grandfather

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Robert Prins
ers assigned. (JP1/JP2 SYSPLEX Symbolics for DFSORT) > > I was looking for a Utility that would examine the value of a Symbolic and > assign a User Return Coe value. RC1 = Development; RC2 = Pre-Production; > RC3 = Production? > I need a Return Code value to be able to conditionally execute s

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Doug Henry
t;From what I have read this is not possible, but I decided to throw it out >there to see if something is possible. > >I have a block of JCL with a bunch f steps. >I have symbolic parameters assigned. (JP1/JP2 SYSPLEX Symbolics for DFSORT) > >I was looking for a Utility that

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Colin Paice
signed. (JP1/JP2 SYSPLEX Symbolics for DFSORT) > > I was looking for a Utility that would examine the value of a Symbolic and > assign a User Return Coe value. RC1 = Development; RC2 = Pre-Production; > RC3 = Production? > I need a Return Code value to be able to conditionally execu

Re: Can DFSORT assign custom Return Code values?

2024-03-04 Thread Sri Hari Kolusu
need since I could write a tiny program for this. Cameron, DFSORT has limited ability to set a return code but not the way you want. However, I think we can solve your issue quite easily by validating the symbol and only generating the steps that needs to run for that Symbolic. Remember

Can DFSORT assign custom Return Code values?

2024-03-04 Thread Cameron Conacher
Hello everyone, From what I have read this is not possible, but I decided to throw it out there to see if something is possible. I have a block of JCL with a bunch of steps. I have symbolic parameters assigned. (JP1/JP2 SYSPLEX Symbolics for DFSORT) I was looking for a Utility that would

Re: DFSORT JOINKEYS problem

2024-02-15 Thread Sri h Kolusu
>> I am really interested in your job that generates the DFSORT symbols for all >> IRRADU00 & IRRDBU00 record types Regards Jack Jack, I have sent an offline email with the PDS that contains the JCL in XMIT format to your personal id (gmail).

Re: DFSORT JOINKEYS problem

2024-02-15 Thread Jack Zukt
ally interested in your job that generates the DFSORT symbols for all IRRADU00 & IRRDBU00 record types Regards Jack On Thu, 15 Feb 2024 at 16:23, Sri h Kolusu wrote: > Jack, > > Since I don't have the joblog, I cannot verify that the input files are VB > or FB as your symbols xtyp

Re: DFSORT JOINKEYS problem

2024-02-15 Thread Sri h Kolusu
evenhave to filter the type records before as the job below reads the output of IRRDBU00 directly) PS: I have a job that generates the DFSORT symbols for all IRRADU00 & IRRDBU00 record types. Let me know if you are interested. //SET#HLQS SET HLQS= //* //SORT001 EXEC PGM=SORT //SYSOUT DD SY

Re: DFSORT JOINKEYS problem

2024-02-15 Thread Massimo Biancucci
Jack, I don't know the exact format of the two files. Did you check (I mean by eyes) the field position are ok ? Is the first SKIP correct ? Best regard. Max Il giorno gio 15 feb 2024 alle ore 16:35 Jack Zukt < 059cd493dd41-dmarc-requ...@listserv.ua.edu> ha scritto: > Hi all, > > I have

DFSORT JOINKEYS problem

2024-02-15 Thread Jack Zukt
Hi all, I have two files created using IRRDBU00. One has type 220 records, TSO segments, the other one has type 200 records, base userid information. For the userids on the 220 type records, I want to get from the 200 type records the userid, user name; last logon date; default group left four

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Sri h Kolusu
llect. I will send an offline email with the updated symbols. 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: Help on DFSORT SUM FIELDS

2023-09-07 Thread Jack Zukt
: > >> DFSORT is a magnificent product but I still am in an very early user > stage. > > Jack, > > Thank you very much. > > >> You are so right about that. I was waiting for having this right before > I would attempt that step. I have to do this in sma

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Sri h Kolusu
>> DFSORT is a magnificent product but I still am in an very early user stage. Jack, Thank you very much. >> You are so right about that. I was waiting for having this right before I >> would attempt that step. I have to do this in small steps. It is quite simple to add it i

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Jack Zukt
Kolusu, You are so right about that. I was waiting for having this right before I would attempt that step. DFSORT is a magnificent product but I still am in an very early user stage. I have to do this in small steps. Thank you once again for your help Best wishes Jack On Thu, 7 Sept 2023 at 16:33

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Sri h Kolusu
63BIT ALLOCATED SPACE IN DCDALLSX Similarly you need to check for record types "B" and "M" Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructio

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Jack Zukt
ting the right > results. If you are still getting incorrect results, then please terse the > DCOLLECT file and send it as an attachment to my email offline and I will > see if I can find something. > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > >

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Sri h Kolusu
ts. If you are still getting incorrect results, then please terse the DCOLLECT file and send it as an attachment to my email offline and I will see if I can find something. Thanks, Kolusu DFSORT Development IBM Corporation --

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Jack Zukt
SP2:UMALLSP)),* MIGRATED SPACE >> >> IFTHEN=(WHEN=NONE, >> OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE >> >> SORT FIELDS=(FMT-HLQ,A) * SORT BY DATASET HLQ >> >> OUTFIL INCLUDE=(FMT-HLQ,EQ,C'JACKZUKT') >

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Jack Zukt
OVERLAY=(TMP-UMALLSP2:UMALLSP)),* MIGRATED SPACE > > IFTHEN=(WHEN=NONE, > OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE > > SORT FIELDS=(FMT-HLQ,A) * SORT BY DATASET HLQ > > OUTFIL INCLUDE=(FMT-HLQ,EQ,C'JAC

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Sri h Kolusu
tput for the field values of all the space fields that you added. Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the

Re: Help on DFSORT SUM FIELDS

2023-09-07 Thread Jack Zukt
ALLOC SPACE > > IFTHEN=(WHEN=(DCURCTYP,EQ,UKTMIGR), > OVERLAY=(TMP-UMALLSP2:UMALLSP)),* MIGRATED SPACE > > IFTHEN=(WHEN=NONE, > OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE > > > > Thanks, > Kolusu > DFSORT

Re: Help on DFSORT SUM FIELDS

2023-09-06 Thread Sri h Kolusu
), OVERLAY=(TMP-UMALLSP2:UMALLSP)),* MIGRATED SPACE IFTHEN=(WHEN=NONE, OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE Thanks, Kolusu DFSORT Development IBM Corporation -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri h Kolusu Sent

Re: Help on DFSORT SUM FIELDS

2023-09-06 Thread Sri h Kolusu
earlier had a similar issue. https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg124452.html Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send em

Help on DFSORT SUM FIELDS

2023-09-06 Thread Jack Zukt
Hi all, I am trying to process DCOLLECT type "D"; "B"; "M"; records in order to get one record by HLQ with the allocated space by active files, migrated files and backup files, and I am doing something wrong because I am getting one output record for each input record, instead of the few hundreds

Re: Syncsort > DFsort migration

2023-08-28 Thread Schmitt, Michael
@LISTSERV.UA.EDU Subject: Re: Syncsort > DFsort migration >> It was the thread in January 12th 2023, with subject "DFSORT maximum input >> records". The message that kicked it off was: Thanks Michael. It is good to know the other products limits. DFSORT has raised the li

Re: Syncsort > DFsort migration

2023-08-28 Thread Sri h Kolusu
>> It was the thread in January 12th 2023, with subject "DFSORT maximum input >> records". The message that kicked it off was: Thanks Michael. It is good to know the other products limits. DFSORT has raised the limit with Sort accelerator to 65,536 times than the

Re: Syncsort > DFsort migration

2023-08-28 Thread Schmitt, Michael
It was the thread in January 12th 2023, with subject "DFSORT maximum input records". The message that kicked it off was: From: Charles Hardee Subject: DFSORT maximum input records MIME-Version: 1.0 I am trying to sort roughly 4295217295, records using DFSORT. DFSORT issues a mess

Re: Syncsort > DFsort migration

2023-08-28 Thread Kirk Wolf
On Mon, Aug 28, 2023, at 11:59 AM, Tom Brennan wrote: > LOL "a while" > Don't worry, IBM would sell you Capacity-on-Demand while the job ran. Kirk Wolf Dovetailed Technologies http://coztoolkit.com -- For IBM-MAIN subscribe /

Re: Syncsort > DFsort migration

2023-08-28 Thread Tom Brennan
LOL "a while" On 8/28/2023 9:49 AM, Sri h Kolusu wrote: I think it was mentioned in this list previously that EQUALS in DFSORT has a lower limit on maximum number of records than SYNCSORT. Michael, Can you please provide link to that topic that mentions that DFSORT has a lower

Re: [EXTERNAL] Re: Syncsort > DFsort migration

2023-08-28 Thread Pommier, Rex
I don't care how fast your computer is, that would take a while to sort! LOL Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri h Kolusu Sent: Monday, August 28, 2023 11:50 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: Syncsort > DFsort migrat

Re: Syncsort > DFsort migration

2023-08-28 Thread Sri h Kolusu
>> I think it was mentioned in this list previously that EQUALS in DFSORT has a >> lower limit on maximum number of records than SYNCSORT. Michael, Can you please provide link to that topic that mentions that DFSORT has a lower limit than the other product? We do have limits an

Re: [EXTERNAL] Re: Syncsort > DFsort migration

2023-08-28 Thread Schmitt, Michael
I think it was mentioned in this list previously that EQUALS in DFSORT has a lower limit on maximum number of records than SYNCSORT. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex Sent: Monday, August 28, 2023 10:54 AM To: IBM-MAIN@LISTSERV.UA.EDU

Re: Syncsort > DFsort migration

2023-08-28 Thread Sri h Kolusu
>> Is this the behavior generally known in IT as a "stable" sort? I find no >> mention of stable sort in the DFSORT documentation. Gil, Yes, EQUALS parm which keeps the dup keys in the order and what some call it as "stable" sort. DFSORT documentatio

Re: [EXTERNAL] Re: Syncsort > DFsort migration

2023-08-28 Thread Pommier, Rex
Gil, I had to look up "stable sort" as I hadn't heard the term. Yes that is what EQUALS does in both DFSort and Syncsort. FYI, I searched the Syncsort programmer's manual and it doesn't mention "stable sort" either. :-) Rex -Original Message- From: IBM Mainf

Re: Syncsort > DFsort migration

2023-08-28 Thread Paul Gilmartin
identically >for a sort or a merge should be preserved from input to output. > Is this the behavior generally known in IT as a "stable" sort? I find no mention of stable sort in the DFSORT documentation. -- gil -

Re: Fwd: Syncsort > DFsort migration

2023-08-28 Thread Sri h Kolusu
>> The only issue I ran into (this was years ago) was that if you use the PARM >> in Syncsort of “EQUAL” expect different output in DFSORT ED, EQUALS is the parm which comes into picture when your input has duplicates on the key, and you want to retain the order of the duplica

Fwd: Syncsort > DFsort migration

2023-08-28 Thread Edward Gould
The only issue I ran into (this was years ago) was that if you use the PARM in Syncsort of “EQUAL” expect different output in DFSORT.. We did not run into this but a friend did. There are items in Syncsort that are different in DFSORT. Syncsort made the decision that some of the (I do not have

  1   2   3   4   5   6   7   8   9   10   >