Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default

Aurora Emanuela Dellanno

Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default

sorry for not putting the header neatly in square brackets but my funny German language keyboard does not have them - meh

 

Question: has anybody else been puzzled that, despite of all the IBM literature clearly stating that the new ZPARM DISALLOW_SEL_INTO_UNION will have a default of YES, in fact the default generated by the CLIST in DSNTIJUZ is NO?

 

I've been scratching my head about this for a few days...

 

Thanks.

 

Aurora

Roland Schock

AW: Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default
(in response to Aurora Emanuela Dellanno)
Hi Aurora,

Press AltGr plus 8 or 9 for the square brackets. ;-)
See attached picture https://drive.google.com/open?id=1_tkWAywqqTWi3BvmbJFWHSdM9WP7xU7X

Mit freundlichen Grüßen/Kind regards
Roland Schock
[ibm-champion-rgb-130px]

Von: Aurora Emanuela Dellanno <[login to unmask email]>
Gesendet: Donnerstag, 6. Februar 2020 13:28
An: [login to unmask email]
Betreff: [Marketing Mail] [DB2-L] - Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default


sorry for not putting the header neatly in square brackets but my funny German language keyboard does not have them - meh



Question: has anybody else been puzzled that, despite of all the IBM literature clearly stating that the new ZPARM DISALLOW_SEL_INTO_UNION will have a default of YES, in fact the default generated by the CLIST in DSNTIJUZ is NO?



I've been scratching my head about this for a few days...



Thanks.



Aurora

-----End Original Message-----
[login to unmask email]
Telefon+Mobil +49 89 32468-130

________________________________
ARS Computer und Consulting GmbH, www.ars.de http://www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software Engineering, Technologieberatung, IBM Software, IBM Lizenzmanagement Services

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://web.ars.de/datenschutz/
Attachments

  • image001.jpg (3.8k)

Chris Hoelscher

Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default
(in response to Aurora Emanuela Dellanno)
PI67611 may govern the default setting in DB2 12



Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: Aurora Emanuela Dellanno <[login to unmask email]>
Sent: Thursday, February 6, 2020 7:28 AM
To: [login to unmask email]
Subject: [DB2-L] - Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default


sorry for not putting the header neatly in square brackets but my funny German language keyboard does not have them - meh



Question: has anybody else been puzzled that, despite of all the IBM literature clearly stating that the new ZPARM DISALLOW_SEL_INTO_UNION will have a default of YES, in fact the default generated by the CLIST in DSNTIJUZ is NO?



I've been scratching my head about this for a few days...



Thanks.



Aurora

-----End Original Message-----

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

Aurora Emanuela Dellanno

RE: Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default
(in response to Aurora Emanuela Dellanno)

Thanks Roland!

 

Chris,

 

don't get me wrong, I'M not complaining about not having to change the default, I'm just puzzled, since from my understanding PI67611 determines only whether the parm is in the ZPARM:

 

DB2 code is modified to disallow a UNION or UNION ALL in
the FROM clause of a SELECT INTO statement.

A new DB2 subsystem parameter is added to DSN6SPRM called
DISALLOW_SEL_INTO_UNION...
The default value of DISALLOW_SEL_INTO_UNION is Yes.

Neil Price

Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default
(in response to Aurora Emanuela Dellanno)
Normally the default is to leave the behaviour unchanged, so it should be
"No" which suggests the APAR text and the docs are wrong - it's not unknown!

Maybe someone got confused, because the default is to allow the UNION /
UNION ALL which sounds as if it should be "Yes".

On Thu, 6 Feb 2020 at 12:28, Aurora Emanuela Dellanno <[login to unmask email]>
wrote:

> sorry for not putting the header neatly in square brackets but my funny
> German language keyboard does not have them - meh
>
>
>
> Question: has anybody else been puzzled that, despite of all the IBM
> literature clearly stating that the new ZPARM DISALLOW_SEL_INTO_UNION will
> have a default of YES, in fact the default generated by the CLIST in
> DSNTIJUZ is NO?
>
>
>
> I've been scratching my head about this for a few days...
>
>
>
> Thanks.
>
>
>
> Aurora
>
> -----End Original Message-----
>

Jan Moeyersons

RE: Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default
(in response to Neil Price)

That's what you get with all those double-negatives… Confusion galore!

 

Why, o, why did they not name it ALLOW_SEL_INTO_UNION ???

 

Jantje.



In Reply to Neil Price:

Normally the default is to leave the behaviour unchanged, so it should be
"No" which suggests the APAR text and the docs are wrong - it's not unknown!

Maybe someone got confused, because the default is to allow the UNION /
UNION ALL which sounds as if it should be "Yes".


Walter Jani&#223;en

RE: Db2 12 z/OS - DISALLOW_SEL_INTO_UNION ZPARM default
(in response to Jan Moeyersons)

Hi Aurora

During our V12 ESP I rebound all our packages and some failed, because they contained a singleton select with a UNION ALL. Allthough it was not documented in the manual, it wirkend. IBM wanted to get rid of this non-documented Feature, but we and other ESP-customer complained a lot. Therefore this ZPARM was introduced and of course the default is YES, nur NO is generated, because you have to change your application, if the package got invalidaded for some reason.