MVSFORUMS.com

dilip

Hi,

Please clarify on the following:

1. Currently we are having OS/390 Ver 2.10 in our mainframe.

Does this version of os/390 provide support for DB2 stored
procedures.

2. Can I use procedural contructs (SUCH AS 'if', 'while', 'declare' and so
on) in the definition of trigger body as shown below :

CREATE TRIGGER MSSD_UPD
AFTER UPDATE ON MSG_STATUS_DIS
REFERENCING NEW AS N_ROW
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
DECLARE CTR INT;
SELECT COUNT(*)
INTO CTR
FROM MSG_STATUS_DIS;
IF CTR > 0 THEN
INSERT INTO MSG_STATUS_DIS
(MSSD_STATUS,MSSD_STATUS_TEXT)
VALUES
(N_ROW.MSSD_STATUS * 5,'NEW ERROR MESG2');
END#

Please help me out ...
_________________
Dilip T.

kolusu · Posted: Sat Nov 15, 2003 11:09 am Post subject:

Dilip,

I answered both of your questions a couple of day back.The answer to your first q can be found here

http://www.mvsforums.com/helpboards/viewtopic.php?t=1417

Once again to clarify, Support for stored procedures does not depend on your operating system, but purely depends on the version of your DB2. If you have DB2 V4 or higher you can run stored procedures.

For your second question check this topic.

http://www.mvsforums.com/helpboards/viewtopic.php?t=1416

Please don't ask the same question twice.

Hope this helps...

cheers

kolusu