Re: Informix System constraints

Quoting Elliot B Dierksen... > > 1) Having a case statement without an "otherwise". The reason was that some > memory is released when a "case" condition is met. There does not have to be > anything executed in the "otherwise". It just needs to exist. > In addition to that, Informix also told us to replace a CASE like this: CASE variable WHEN constant1 ...... WHEN constant2 ...... WHEN constant3 ...... OTHERWISE ...... END CASE with something like this: CASE WHEN variable = constant1 ...... WHEN variable = constant2 ...... WHEN variable = constant3 ...... OTHERWISE ...... END CASE > 2) Use "call function(argument) returning variable" instead of > "let variable = function(argument)". For some unknown reason, Informix likes > example one better. > That makes sense, however, we've been told to avoid the first example because it causes un-needed stack usage and is therefore slower. I wish the guys at Informix would agree on one form or the other. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.4 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com