case or if outside query

ahmedwaseem2000 · #1 (**permalink**) 03-22-07, 02:59

Hi is there a way to write case or if clause before running a query. like if a condition is satisfied then update or insert???

stolze · #2 (**permalink**) 03-22-07, 06:28

You can use a compound statement:

Code:

BEGIN
   IF <condition> THEN
      <statement>;
   ELSE
      <statement>;
   END IF;
END

If you only worry about insert vs. update, then have a look at the MERGE statement. That gives you the best performance because all the decisions are evaluated internally to DB2 in a more optimized fashion than a procedural approach like above could do.

sathyaram_s · #3 (**permalink**) 03-22-07, 13:26

Not sure what your actual reqmt is - But check the usage of MERGE statement ... That might help

Sathyaram

Internet Services

Web Development

Digital Marketing

Consumer Tech