Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).
-- Generate SQL -- Version: V7R1M0 100423 -- Generated on: 10/30/13 08:01:43 -- Relational Database: S10F3EC1 -- Standards Option: DB2 for i CREATE PROCEDURE GB1555AFGD.SOAP_TRIGGER ( IN DID CHAR(15) ) LANGUAGE CL SPECIFIC GB1555AFGD.SOAP_TRIGGER DETERMINISTIC NO SQL CALLED ON NULL INPUT EXTERNAL NAME 'MYLIB/Z1CRMTCMD' PARAMETER STYLE SQL ;
CREATE TRIGGER GB1555AFGD.C8_SYNCJOURNAL_INSERTS AFTER INSERT ON GB1555AFGD.Z1ODBJC82 REFERENCING NEW AS NEW_ROW FOR EACH ROW MODE DB2SQL SET OPTION ALWBLK = *ALLREAD , ALWCPYDTA = *OPTIMIZE , COMMIT = *NONE , DECRESULT = (31, 31, 00) , DFTRDBCOL = *NONE , DYNDFTCOL = *NO , DYNUSRPRF = *USER , SRTSEQ = *HEX WHEN ( NEW_ROW . DJID IS NOT NULL ) BEGIN ATOMIC CALL GB1555AFGD . SOAP_TRIGGER ( 'NEW_NOW.DJID' ) ; END ;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.