Re: DFSORT - Something I can't see.

2024-07-26 Thread Massimo Biancucci
Sri, it's true, indeed and it's outside of my control (this case I'm not the SYSPROG). Back to your explanation, I do understand DFSORT ... "So VLSHRT tells DFSORT to treat any comparison involving a short field as false." This case anyway I've two conditions in OR, one of the t

Re: DFSORT - Something I can't see.

2024-07-26 Thread Sri Hari Kolusu
> thanks a lot it obviously (now :D) worked. I would have preferred an error. Max, I am guessing your shop has VLSHRT as the default. Here is a topic that describes the effects of VLSHRT https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg92247.html Thanks, Kolusu DFSORT Developm

Re: DFSORT - Something I can't see.

2024-07-26 Thread Massimo Biancucci
; add OPTION VLSCMP to the SYSIN and re-run the job. > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, >

Re: DFSORT - Something I can't see.

2024-07-26 Thread Sri Hari Kolusu
> Input is a VBA dataset. Massimo, Since the input is VBA, the short records may be the difference. Please add OPTION VLSCMP to the SYSIN and re-run the job. Thanks, Kolusu DFSORT Development IBM Corporation -- For

DFSORT - Something I can't see.

2024-07-26 Thread Massimo Biancucci
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

Re: DFSORT / SORT and value/necessity of FILSZ parameter

2024-07-22 Thread Verwijs, Frederick F [NC]
Mainframe Discussion List On Behalf Of Sri Hari Kolusu Sent: Sunday, July 21, 2024 7:32 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT / SORT and value/necessity of FILSZ parameter >> We use OPTION COPY. Eric, Option COPY does NOT require FILSZ parameter. It is required when SORTing data

Re: DFSORT / SORT and value/necessity of FILSZ parameter

2024-07-21 Thread Sri Hari Kolusu
>> We use OPTION COPY. Eric, Option COPY does NOT require FILSZ parameter. It is required when SORTing data which helps in calculating the workspace required. DFSORT issues an informational message ICE118I when it couldn't determine the file size. https://www.ibm.com/docs/en/zos

Re: DFSORT / SORT and value/necessity of FILSZ parameter

2024-07-21 Thread Verwijs, Frederick F [NC]
frederick.verw...@hrsdc-rhdcc.gc.ca Telephone 613-415-5465 -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri Hari Kolusu Sent: Friday, July 19, 2024 3:29 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT / SORT and value/necessity of FILSZ parameter >> We run sort

Re: DFSORT / SORT and value/necessity of FILSZ parameter

2024-07-19 Thread Sri Hari Kolusu
E 0 FOR COPY, MERGE OR SORTOUT) 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 / SORT and value/necessity of FILSZ parameter

2024-07-19 Thread Verwijs, Frederick F [NC]
Hello All, Unless I'm misreading the manual, from the DFSORT Application Programming Guide, FILSZ can be used to improve performance. We run sort splits on large tape datasets, with over a hundred million records. They get split into 3 separate datasets, depending on the data. These jobs do

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Schmitt, Michael
IBM Mainframe Discussion List On Behalf Of Sri Hari Kolusu Sent: Tuesday, June 25, 2024 11:36 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT Question regarding SORTOUT Library Member Statistics > I don't think that option is on the template workbench. Michael, I don't use workbench, b

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Jack Zukt
ent: Tuesday, June 25, 2024 11:01 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT Question regarding SORTOUT Library Member Statistics > > >> I want to know if I can include an option, or processing clause to > ensure that Library statistics are generated for each new member a

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Sri Hari Kolusu
> I don't think that option is on the template workbench. Michael, I don't use workbench, but I am assuming that it does let you EDIT the template. If it does , then just add/Modify the stats parm in the template. Thanks, Kolusu

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Schmitt, Michael
I don't think that option is on the template workbench. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri Hari Kolusu Sent: Tuesday, June 25, 2024 11:26 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT Question regarding SORTOUT Library Member Statistics

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Sri Hari Kolusu
he ISPF statistics that exist for members being processed are always updated and statistics for a member that previously did not have statistics are created. Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN s

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Schmitt, Michael
where what's provided in input or a DD is a library, not a library(member). So DFSORT sorting to a library(member) wouldn't create stats. For the OP question, I think the respondents have hit all the options to create ISPF stats... * ISPF 3.5 (usually the best method in ISPF) * ISPF Edit, save

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Cameron Conacher
Fantastic!! Thanks …….Cameron From: IBM Mainframe Discussion List On Behalf Of Sri Hari Kolusu Sent: Tuesday, June 25, 2024 11:42 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT Question regarding SORTOUT Library Member Statistics >> Or just Enter/SAVE/F3 a couple of hundred

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread David Spiegel
To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT Question regarding SORTOUT Library Member Statistics I want to know if I can include an option, or processing clause to ensure that Library statistics are generated for each new member as I create them. At the moment, I have a couple of hundred new

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Paul Gilmartin
On Tue, 25 Jun 2024 18:24:52 +, Robert Prins wrote: >Or if you don't care about stats, just that they are set, ISPF 3.5 > ISRSUPC with the UPDMVS8 option generates a patch file. But is there any tool to apply such a patch and update the stats, and even the revision level in cols. 73-80? --

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Sri Hari Kolusu
SuperCE e e 14. Search-For e e 15. Search-ForE e e 16. Table Utilitye e 17. Directory List e DM Thanks, Kolusu DFSORT Developm

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Paul Gilmartin
On Tue, 25 Jun 2024 15:01:20 +, Sri Hari Kolusu wrote: > >Unfortunately, ... > <https://en.wikipedia.org/wiki/Conway%27s_law> >DFSORT does NOT copy/generate member statistics when copying. However, if >your shop has FILE-MANAGER, then you can use the following. &

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Robert Prins
anks. >> I can try that. >> Or just Enter/SAVE/F3 a couple of hundred times.  >> >> Appreciate the information as always. >> >> >> Thanks >> >> …….Cameron >> >> >> From: IBM Mainframe Discussion List On Behalf >> Of Sri Hari Ko

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Robert Prins
n > > > From: IBM Mainframe Discussion List On Behalf > Of Sri Hari Kolusu > Sent: Tuesday, June 25, 2024 11:01 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT Question regarding SORTOUT Library Member Statistics > > >> I want to know if I can include an opti

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Willy Jensen
Wouldn't that set the statistics to the current date and time, plus the userid of the SORT job? Also, if you have File Manager, I assume that it could do the copy, including statistics. As a free alternative to File Manager, see PDS86 at cbttape.org file 182.

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Farley, Peter
If you have the free PDS tool from the CBTTAPE site, that tool also allows you to add ISPF statistics to an existing member. Peter From: IBM Mainframe Discussion List On Behalf Of Cameron Conacher Sent: Tuesday, June 25, 2024 11:17 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT Question

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Cameron Conacher
Thanks. I can try that. Or just Enter/SAVE/F3 a couple of hundred times.  Appreciate the information as always. Thanks …….Cameron From: IBM Mainframe Discussion List On Behalf Of Sri Hari Kolusu Sent: Tuesday, June 25, 2024 11:01 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Sri Hari Kolusu
created when last changed, etc..). Cameroon, Unfortunately, DFSORT does NOT copy/generate member statistics when copying. However, if your shop has FILE-MANAGER, then you can use the following. //STEP0100 EXEC PGM=FILEMGR //SYSPRINT DD SYSOUT=* //DDIN DD DISP=SHR,DSN=Your.input //DDOUTDD

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Cameron Conacher
Subject: Re: DFSORT Question regarding SORTOUT Library Member Statistics Would the ISPF LM Services, i. e. LMCOPY, provide the results you want? Sent with Proton Mail secure email. On Tuesday, June 25th, 2024 at 10: 42 AM, Cameron Conacher <03cfc59146bb-dmarc-request@ LISTSERV. UA. EDU>

Re: DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread rpinion865
Would the ISPF LM Services, i.e. LMCOPY, provide the results you want? Sent with Proton Mail secure email. On Tuesday, June 25th, 2024 at 10:42 AM, Cameron Conacher <03cfc59146bb-dmarc-requ...@listserv.ua.edu> wrote: > Hello everyone, > I believe I simply cannot do this

DFSORT Question regarding SORTOUT Library Member Statistics

2024-06-25 Thread Cameron Conacher
Hello everyone, I believe I simply cannot do this using DFSORT, but I wanted to confirm with the wider/wiser team. I have create a little DFSORT Utility to clone JCL/PROCs/Control Statement etc... by copying selected members from a Library to another Library with little Market changes

Re: DFSort query

2024-05-22 Thread Ron Thomas
My Apologies Kolusu for wrong details inputted Thanks Much for the sample job and it is working good for my requirement. Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

Re: DFSORT Fixed Records to CSV - Trim Extraneous Blanks?

2024-05-21 Thread Sri Hari Kolusu
>>> Is this doable in DFSORT? If so, can help point me to some examples / >>> suggested reading / command statements? Steve, Yes DFSORT can do it quite easily. Since you haven't provided any details about LRECL/RECFM here is sample that I came up on the fly. Run t

DFSORT Fixed Records to CSV - Trim Extraneous Blanks?

2024-05-21 Thread Steve Estle
Hello All, I looked back at history of DFSORT questions / answers and didn't see anything that quite matched up on this. My question is the following - I have a sharp App Developer I work with who is very good with SAS but can't quite get SAS to do what he wants - long story. In a nutshell

Re: DFSort query

2024-05-21 Thread Sri Hari Kolusu
quence number which you want to validate to pull the desired records. >> Could someone please let me know how we can build this data using dfsort ? If you had searched, you would have found the DFSORT Smart trick “Include or omit groups of records” which caters to your exact require

Re: DFSort query

2024-05-21 Thread Retired Mainframer
Have you considered using IFTHEN-WHEN constructs? -Original Message- From: IBM Mainframe Discussion List On Behalf Of Ron Thomas Sent: Tuesday, May 21, 2024 10:01 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: DFSort query Hi All- In the below Data we need to extract with in the cross ref

DFSort query

2024-05-21 Thread Ron Thomas
1500013748790 592670711500013748790 600392811 1500013748790 600392561 1762220138631 Data size Acct _NBR 10 bytes Pacct_NBR 15 bytes LAST_CHANGE_TS 20 bytes CROSS_REF_NBR 5 bytes SEQ_NBR 2 bytes Could someone please let me know how we can build this data using dfsort ? Regards Ron T

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

  1   2   3   4   5   6   7   8   9   10   >