Re: DFSORT and "IF exist"

2021-09-06 Thread Bernd Oppolzer
Thanks, this looks very good; the header on page 14 describes exactly what I had in mind: Join fields from two files on a key In this section, we show some tricks for joining fields from two files in different ways using the JOINKEYS function of DFSORT Radoslaw will sure be able to do the

Re: RENT binder option - note of thanks!

2021-09-06 Thread Lennie Dymoke-Bradshaw
Doh... Like count = Like count + 1 -Original Message- From: IBM Mainframe Discussion List On Behalf Of Lennie Bradshaw Sent: 07 September 2021 00:06 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: RENT binder option - note of thanks! Like count = Link count + 1 -Original Message-

Re: RENT binder option - note of thanks!

2021-09-06 Thread Lennie Bradshaw
Like count = Link count + 1 -Original Message- From: IBM Mainframe Discussion List On Behalf Of Tom Brennan Sent: 06 September 2021 22:02 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: RENT binder option - note of thanks! Like count=1 On 9/6/2021 1:15 PM, Mike Hochee wrote: > Just a word

Re: DFSORT and "IF exist"

2021-09-06 Thread Joe Monk
I would suggest using DFSORT with JOINKEYS. See the example on page 15 here: https://www.ibm.com/support/pages/system/files/inline-files/$FILE/sorttrck.pdf Joe On Mon, Sep 6, 2021 at 4:24 PM Bernd Oppolzer wrote: > Hi Radoslaw, > > I am not a DFSORT wizard, but: > > this is similar to a

Re: DFSORT and "IF exist"

2021-09-06 Thread Bernd Oppolzer
Hi Radoslaw, I am not a DFSORT wizard, but: this is similar to a INNER JOIN SQL query; if I had a DB2 system at hand, I would load the SUM and ABC records into two different DB2 tables and do a SELECT statement involving an inner join, this would give the desired result. Maybe the same can

Re: RENT binder option - note of thanks!

2021-09-06 Thread Tom Brennan
Like count=1 On 9/6/2021 1:15 PM, Mike Hochee wrote: Just a word of thanks to the IBM heavyweights (Jim, Peter, Sri, et. al.) to whom a debt of gratitude is owed for their deep-water expertise, patience, and willingness to share knowledge when they undoubtedly have many other things to work

Re: RENT binder option - note of thanks!

2021-09-06 Thread Mike Hochee
Just a word of thanks to the IBM heavyweights (Jim, Peter, Sri, et. al.) to whom a debt of gratitude is owed for their deep-water expertise, patience, and willingness to share knowledge when they undoubtedly have many other things to work on. I suspect there are many subscriber motivations

DFSORT and "IF exist"

2021-09-06 Thread Radoslaw Skorupka
I have the following task to do: PS file, VB records, different types. Two types are in scope of interest: SUMeeeNAME123456eee... ABCeNAME123456e SUM and ABC are record identifiers. NAME123456 is 10-char field I need to analyze e is irrelevant content. The

Re: RENT binder option

2021-09-06 Thread Seymour J Metz
A module in an authorized concatenation with the RENT attribute will go into SP 252 key 0 storage even if it doesn't have the REFR attribute. I don't recall whether it will also be page protected. With some changes in detail, that behavior goes all the way back to OS/360 MVT. -- Shmuel

Re: RENT binder option

2021-09-06 Thread Paul Gilmartin
On Sat, 4 Sep 2021 18:34:36 +1000, Andrew Rowley wrote: >... >I ran into this many years ago when I "cleaned up" and removed an empty >library from the STEPLIB of one of our subsystems. That suddenly meant >that the STEPLIB was considered APF authorized, which resulted in S0C4 >abends when the

Re: SMP/E and RENT binder option

2021-09-06 Thread Seymour J Metz
In a PTF, I believe that you need the ++ DELETE; I believe that you can force a rebuild with a RESTORE and APPLY. Possibly ++ JCLIN? -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU]

Re: RENT binder option

2021-09-06 Thread Seymour J Metz
Earlier statements in this thread? No. Earlier statements in other threads? Many times. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 לְשָׁנָה טוֹבָה תִכָּתֵבוּ וְתֵּחָתֵמוּ From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on

SMP/E and RENT binder option

2021-09-06 Thread Paul Gilmartin
On Mon, 6 Sep 2021 15:19:48 +, Seymour J Metz wrote: >Yes, BTDT,GTTS. IMHO, installing PDS86, StarTool oe whatever the current name >is, is a no brainer, and we owe Bruce a debt of gratitude. > What path does SMP/E, which does not supporrt the StarTool utility, provide for upgrading a load

Re: RENT binder option

2021-09-06 Thread David Spiegel
Hi R'Shmuel AMV"SH, Don't you agree that your earlier statement has been refuted? Please see:  פרקי אבות  5:9 שׁוֹאֵל כְּעִנְיָן וּמֵשִׁיב כַּהֲלָכָה Regards, David On 2021-09-06 11:19, Seymour J Metz wrote: Yes, BTDT,GTTS. IMHO, installing PDS86, StarTool oe whatever the current name is, is a no

Re: RENT binder option

2021-09-06 Thread Seymour J Metz
Yes, BTDT,GTTS. IMHO, installing PDS86, StarTool oe whatever the current name is, is a no brainer, and we owe Bruce a debt of gratitude. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List

Re: SMF field data

2021-09-06 Thread Martin Packer
Glad you found it. Seems your Db2 subsystems aren't entirely cloned... ... I was pondering Datasharing Group level things versus Subsystem things. DSNZPARM is, of course, a Subsystem thing - so members even in the same Datasharing Group can have different DSNZPARM values, such as this one.