db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer

Dave Nance

db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer
 David Nance 804-683-1507

From: Dave Nance <[login to unmask email]>
To: IDUG DB2-L <[login to unmask email]>
Sent: Wednesday, July 26, 2017 11:16 AM
Subject: db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer

   Using RC/Query I type DDL beside a table name to get the DDL for recreating. The ALTER statement to add a foreign key is coming out incorrectly. As you can see below, its throwing in parms that it shouldn't: the AUDIT, APPEND, NOT VOLATILE, etc... I've look through the EDIT parmlib Members option and do not see anything that looks like it might change this behavior. I've passed it off to the staff here at the site I'm at, but may take some time for them to contact CA and get back to me.
  ALTER TABLE "PARISP  ".TPRS_PWN_NME
       ADD
       CONSTRAINT FPWNAFL1
       FOREIGN KEY
      (PWN_CURR_AFFL_CD
      )
       REFERENCES "PARISP  ".TPRS_AFL_AFFILIATN ON DELETE RESTRICT
       ENFORCED
 AUDIT NONE
 APPEND NO
 VALIDPROC NULL
 DATA CAPTURE CHANGES
 NOT VOLATILE CARDINALITY; 

David Nance 804-683-1507

John Bucaria

db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer
(in response to Dave Nance)
Dave,
We have Version 17 of RC/Query and it exhibits the same anomaly. What version are you running?
John

From: Dave Nance [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 12:25 PM
To: Lizette Koehler <[login to unmask email]>
Subject: [DB2-L] - RE: db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer


David Nance
804-683-1507

________________________________
From: Dave Nance <[login to unmask email]<mailto:[login to unmask email]>>
To: IDUG DB2-L <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Wednesday, July 26, 2017 11:16 AM
Subject: db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer

Using RC/Query I type DDL beside a table name to get the DDL for recreating. The ALTER statement to add a foreign key is coming out incorrectly. As you can see below, its throwing in parms that it shouldn't: the AUDIT, APPEND, NOT VOLATILE, etc... I've look through the EDIT parmlib Members option and do not see anything that looks like it might change this behavior. I've passed it off to the staff here at the site I'm at, but may take some time for them to contact CA and get back to me.

ALTER TABLE "PARISP ".TPRS_PWN_NME
ADD
CONSTRAINT FPWNAFL1
FOREIGN KEY
(PWN_CURR_AFFL_CD
)
REFERENCES "PARISP ".TPRS_AFL_AFFILIATN ON DELETE RESTRICT
ENFORCED
AUDIT NONE
APPEND NO
VALIDPROC NULL
DATA CAPTURE CHANGES
NOT VOLATILE CARDINALITY;



David Nance
804-683-1507


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

James Campbell

db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer
(in response to Dave Nance)
RC/Query V19 and DB2 V11 NFM doesn't show this behaviour. AUDIT, APPEND, etc are
on the CREATE TABLE and not on the ALTER.

But is what you are seeing "incorrect"? If they are *not* on the CREATE and only on the
ALTER, then yes - it would be incorrect. If they are on *both* the CREATE and ALTER
then, while superfluous, is it actually an error?

James Campbell

On 26 Jul 2017 at 16:24, Dave Nance wrote:

>
>  
> David Nance
> 804-683-1507
>
>
>
> From: Dave Nance <[login to unmask email]>
> To: IDUG DB2-L <[login to unmask email]>
> Sent: Wednesday, July 26, 2017 11:16 AM
> Subject: db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the
> answer
>
>    Using RC/Query I type DDL beside a table name to get the DDL for recreating. The
> ALTER statement to add a foreign key is coming out incorrectly. As you can see below,
> its throwing in parms that it shouldn't: the AUDIT, APPEND, NOT VOLATILE, etc... I've
> look through the EDIT parmlib Members option and do not see anything that looks like it
> might change this behavior. I've passed it off to the staff here at the site I'm at, but may
> take some time for them to contact CA and get back to me.
>
>   ALTER TABLE "PARISP  ".TPRS_PWN_NME
>        ADD
>        CONSTRAINT FPWNAFL1
>        FOREIGN KEY
>       (PWN_CURR_AFFL_CD
>       )
>        REFERENCES "PARISP  ".TPRS_AFL_AFFILIATN ON DELETE RESTRICT
>        ENFORCED
>  AUDIT NONE
>  APPEND NO
>  VALIDPROC NULL
>  DATA CAPTURE CHANGES
>  NOT VOLATILE CARDINALITY;
>  
>
>
> David Nance
> 804-683-1507
>
>

John Bucaria

db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer
(in response to James Campbell)
I typically get an error on the VALIDPROC clause.

-----Original Message-----
From: James Campbell [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 8:56 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer

RC/Query V19 and DB2 V11 NFM doesn't show this behaviour. AUDIT, APPEND, etc are on the CREATE TABLE and not on the ALTER.

But is what you are seeing "incorrect"? If they are *not* on the CREATE and only on the ALTER, then yes - it would be incorrect. If they are on *both* the CREATE and ALTER then, while superfluous, is it actually an error?

James Campbell

On 26 Jul 2017 at 16:24, Dave Nance wrote:

>
>  
> David Nance
> 804-683-1507
>
>
>
> From: Dave Nance <[login to unmask email]>
> To: IDUG DB2-L <[login to unmask email]>
> Sent: Wednesday, July 26, 2017 11:16 AM
> Subject: db2 z/OS V10 actually a CA question, but thought I'd see if
> anyone here knows the answer
>
>    Using RC/Query I type DDL beside a table name to get the DDL for
> recreating. The ALTER statement to add a foreign key is coming out
> incorrectly. As you can see below, its throwing in parms that it
> shouldn't: the AUDIT, APPEND, NOT VOLATILE, etc... I've look through
> the EDIT parmlib Members option and do not see anything that looks
> like it might change this behavior. I've passed it off to the staff here at the site I'm at, but may take some time for them to contact CA and get back to me.
>
>   ALTER TABLE "PARISP  ".TPRS_PWN_NME
>        ADD
>        CONSTRAINT FPWNAFL1
>        FOREIGN KEY
>       (PWN_CURR_AFFL_CD
>       )
>        REFERENCES "PARISP  ".TPRS_AFL_AFFILIATN ON DELETE RESTRICT
>        ENFORCED
>  AUDIT NONE
>  APPEND NO
>  VALIDPROC NULL
>  DATA CAPTURE CHANGES
>  NOT VOLATILE CARDINALITY;
>  
>
>
> David Nance
> 804-683-1507
>
>

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

Dave Nance

db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer
(in response to John Bucaria)
 We are on V17 as well.David Nance 

From: "Bucaria, John" <[login to unmask email]>
To: "[login to unmask email]" <[login to unmask email]>
Sent: Wednesday, July 26, 2017 3:50 PM
Subject: [DB2-L] - RE: db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer

<!--#yiv6302231499 _filtered #yiv6302231499 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv6302231499 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv6302231499 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv6302231499 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv6302231499 #yiv6302231499 p.yiv6302231499MsoNormal, #yiv6302231499 li.yiv6302231499MsoNormal, #yiv6302231499 div.yiv6302231499MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", serif;}#yiv6302231499 a:link, #yiv6302231499 span.yiv6302231499MsoHyperlink {color:blue;text-decoration:underline;}#yiv6302231499 a:visited, #yiv6302231499 span.yiv6302231499MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv6302231499 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", serif;}#yiv6302231499 span.yiv6302231499EmailStyle18 {font-family:"Calibri", sans-serif;color:#1F497D;}#yiv6302231499 .yiv6302231499MsoChpDefault {font-size:10.0pt;} _filtered #yiv6302231499 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv6302231499 div.yiv6302231499WordSection1 {}-->Dave, We have Version 17 of RC/Query and it exhibits the same anomaly.  What version are you running? John     -----End Original Message-----
Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: [login to unmask email] a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Dave Nance

db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer
(in response to John Bucaria)
James,   On a straight alter of the table those clauses work fine. However, since we are ALTER ADDING a constraint, we do get an error. It may be just the VALIDPROC as John mentioned. We have just been deleting the whole set. David Nance


From: "Bucaria, John" <[login to unmask email]>
To: "[login to unmask email]" <[login to unmask email]>
Sent: Thursday, July 27, 2017 11:00 AM
Subject: [DB2-L] - RE: db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer

I typically get an error on the VALIDPROC clause.

-----Original Message-----
From: James Campbell [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 8:56 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: db2 z/OS V10 actually a CA question, but thought I'd see if anyone here knows the answer

RC/Query V19 and DB2 V11 NFM doesn't show this behaviour.  AUDIT, APPEND, etc are on the CREATE TABLE and not on the ALTER.

But is what you are seeing "incorrect"?  If they are *not* on the CREATE and only on the ALTER, then yes - it would be incorrect.  If they are on *both* the CREATE and ALTER then, while superfluous, is it actually an error?

James Campbell

On 26 Jul 2017 at 16:24, Dave Nance wrote:

>
>  
> David Nance
> 804-683-1507
>
>
>
> From: Dave Nance <[login to unmask email]>
> To: IDUG DB2-L <[login to unmask email]>
> Sent: Wednesday, July 26, 2017 11:16 AM
> Subject: db2 z/OS V10 actually a CA question, but thought I'd see if
> anyone here knows the answer
>
>    Using RC/Query I type DDL beside a table name to get the DDL for
> recreating. The ALTER statement to add a foreign key is coming out
> incorrectly. As you can see below, its throwing in parms that it
> shouldn't: the AUDIT, APPEND, NOT VOLATILE, etc... I've look through
> the EDIT parmlib Members option and do not see anything that looks
> like it might change this behavior. I've passed it off to the staff here at the site I'm at, but may take some time for them to contact CA and get back to me.
>
>   ALTER TABLE "PARISP  ".TPRS_PWN_NME
>        ADD
>        CONSTRAINT FPWNAFL1
>        FOREIGN KEY
>       (PWN_CURR_AFFL_CD
>       )
>        REFERENCES "PARISP  ".TPRS_AFL_AFFILIATN ON DELETE RESTRICT
>        ENFORCED
>  AUDIT NONE
>  APPEND NO
>  VALIDPROC NULL
>  DATA CAPTURE CHANGES
>  NOT VOLATILE CARDINALITY;
>  
>
>
> David Nance
> 804-683-1507
>
>
   
-----End Original Message-----   
   
-----End Original Message-----