OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
division by zero / Insert Statment

From: Raik Thalheim (rtnative-works.com)
Date: Fri Apr 16 2004 - 04:33:42 CDT

Dear list,

To prevent a division by zero
i examine the divisor for zero.

INSERT INTO "TEMP"."TABLE2"
(COLUMN1)
SELECT
CASE
    WHEN SOURCECOL = 0 THEN 0
    WHEN SOURCECOL <> 0 THEN (Sum(SOURCECOL3/SOURCECOL))
END AS REAGENZ
FROM "TEMP"."TABLE1"
GROUP BY SOURCECOL;

Does not functioned for "Insert into ... ".

Is using the "case" statement in combination with "insert" possible ?

Best Regards,

Raik Thalheim

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb