MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

'MODE DB2SQL' in DB2 trigger

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
dilip
Beginner


Joined: 08 Nov 2003
Posts: 7
Topics: 7
Location: india

PostPosted: Mon Nov 17, 2003 10:18 pm    Post subject: 'MODE DB2SQL' in DB2 trigger Reply with quote

Hi,

What is the significance of specifying 'MODE DB2SQL' in the definition of a trigger ..... For example


CREATE TRIGGER MSSD_UPD
AFTER UPDATE ON MSG_STATUS_DIS
REFERENCING NEW AS N_ROW
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
< SQL STMTS >
END


What are the other possible modes?
_________________
Dilip T.
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
ofer71
Intermediate


Joined: 12 Feb 2003
Posts: 358
Topics: 4
Location: Israel

PostPosted: Mon Nov 17, 2003 10:21 pm    Post subject: Reply with quote

Hi

As for now, there are no other modes, as the fine manual says.

O.
________
Toyota Yaris Verso specifications
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group