Hi
Look at this
https://www.ibm.com/support/knowledgecenter/en/SSR27Q_4.0.7/com.ibm.rational.rtc.rdz.doc/topics/rdzrtcz_int_user_build_jcl.html
Em 06/02/2018 17:02, Paul Gilmartin escreveu:
> On Tue, 6 Feb 2018 10:49:38 -0800, Tom Ross wrote:
>
>> For background, this is where you can
Maybe something like this (I am ot sure):
CREATE TRIGGER PU_UPD_PPSTA
AFTER UPDATE OF LCR ON PPSTA
REFERENCING OLD AS O NEW AS N
FOR EACH ROW
MODE DB2SQL
BEGIN ATOMIC
UPDATE HIST SET LCR.HIST = LCR.PPSTA
END;
Em 13/10/2017 8:38, Paulo Roberto Leonardo Pereira escreveu:
> I n
I need to know how can I get examples of triggers to update a different
table from an update on another one.
I have a table called PPSTA which have an atribute called LCR. Another
table called HIST has the same attribute. Also sometimes the PPSTA table
will have a mass update to which need to
DB2 for z/OS version 10 changed the string format of decimals. we are using
Enterprise PL/I. Does a built-in function exist which can help us with the
new format decimal number strings? Is there a recommendation for a
technique which handles such numbers?
Thanks
would like to join the DB2 Newsgroup, go
to www.idug.org
Lizette
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Paulo Roberto Leonardo Pereira
Sent: Thursday, May 16, 2013 9:16 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DB2