Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
division by zero / Insert Statment
From: Raik Thalheim (rtnative-works.com)
Date: Fri Apr 16 2004 - 04:33:42 CDT
To prevent a division by zero
i examine the divisor for zero.
INSERT INTO "TEMP"."TABLE2"
WHEN SOURCECOL = 0 THEN 0
WHEN SOURCECOL <> 0 THEN (Sum(SOURCECOL3/SOURCECOL))
END AS REAGENZ
GROUP BY SOURCECOL;
Does not functioned for "Insert into ... ".
Is using the "case" statement in combination with "insert" possible ?
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb