Re: 7.30 Performance problems

"Art S. Kagel" <kagel@bloomberg.net> offerred: +I have the explanation. CASE is now a keyword in 7.3. V7.3 added the +Oracle CASE clause syntax to the select statement. Just a minor quibble on details: Oracle, as far as I am aware, does NOT have a CASE statement. They do have DECODE() which Informix has also added in 7.3. The CASE statement turns out to be even more flexible than the DECODE() function, as you can handle more complex expressions easily in the CASE statement. Dave ** Dave Kosenko <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training