Return immediately !!

DBFinder · #1 (**permalink**) 11-13-08, 15:30

Hi Everyone,

While I was writig TRIGGER at my job - I needed to return without doing anything. Just as the functions return with RETURN. Can some one help me with the statement to return. or NULL statement.

If <condition> then

do nothing ; --- (RETURN) here don't even go further
else
do something;
end if

I am simply writing just to explain but at workplace the developer had written it thisway conditions were multiple and negetion was quite difficult.
I told them to do otherway but they insisted. As trigger works fine I did not insist.

Please advise me proper DB2 statement to return.

Thanks
DBFinder

n_i · #2 (**permalink**) 11-13-08, 16:29

Try the LEAVE statement.

stolze · #3 (**permalink**) 11-13-08, 16:46

I don't see what would be difficult with negating the condition. How about:

Code:

IF NOT ( <condition> ) THEN
   -- do something
END IF;

Alternatively, you could put an empty BEGIN END block in the then-branch. But that is just cluttering the trigger and unprofessional bad practice (harder to maintain).

DBFinder · #4 (**permalink**) 11-13-08, 16:53

Good,

Thanks to both of you.

DBFinder

Internet Services

Web Development

Digital Marketing

Consumer Tech