Re: NOOP in SQL procedure? And other questions

Unfortunately that confuses a CASE statement with a CASE expression. The former is a /SQL control statement/ whereas the latter is an expression that effectively evaluates to a scalar value based upon WHEN predicates; i.e. the CASE expression is an effective arithmetic expression or string expression, according to the type of data into which the expression evaluates.

http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcasestmt.htm
IBM i 7.1 Information Center -> Database -> Reference -> SQL reference -> SQL control statements
_i CASE statement i_
"The CASE statement selects an execution path based on multiple conditions.
..."

http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcaseexp.htm
IBM i 7.1 Information Center > Database > Reference > SQL reference > Language elements > Expressions
_i CASE expression i_
"CASE expressions allow an expression to be selected based on the evaluation of one or more conditions.
..."

Regards, Chuck

On 17 Apr 2013 06:28, Michael Schutte wrote:

You can use NULL.

From SQL Reference manual.

"CASE expressions allow an expression to be selected based on the
evaluation of one or more conditions. In general, the value of the
case-expression is the value of the result-expression following the
first (leftmost) when-clause that evaluates to true. If no
when-clause evaluates to true and the ELSE keyword is present then
the result is the value of the ELSE result-expression or NULL. If no
when-clause evaluates to true and the ELSE keyword is not present
then the result is NULL. Note that when a when-clause evaluates to
unknown (because of nulls), the when-clause is not true and hence is
treated the same way as a when-clause that evaluates to false."

On Wed, Apr 17, 2013 at 9:01 AM, Vernon Hamberg wrote:

Thanks for this - I didn't think I could use NULL - it is not
documented as a statement that I could find, while it is in Oracle
and maybe other RDBMS.

On 4/17/2013 7:45 AM, Michael Schutte wrote:

Vern if you are using DECLARE GLOBAL. Then put a WITH REPLACE at
the end to replace the existing table.

Also for the else. I using put ELSE NULL