DB2条件WHERE子句 [英] DB2 Conditional WHERE clause

问题描述

我正在使用DB2 v9

I'm using DB2 v9

我有一个带有参数的存储过程，这些参数有可能作为空字符串传递。以下是我要执行的操作的伪代码：

I have a stored procedure with paramaters that can potentially be passed in as empty strings. Here somer pseudocode for what I'm trying to do:

WHERE myColumn.name =
     IF param1 = '' THEN
        **disregard this param, all column values are eligible**
     ELSE
        myColumn.name = param1;

如果它是一个空字符串，则基本上忽略该参数。如果不是，请在WHERE子句中将其用作过滤器。

Basically just ignore the param if it is an empty string. If not, apply it as a filter in the WHERE clause. Is this possible to do in DB2?

推荐答案

SELECT ...
FROM ...
WHERE  param1 = '' 
   OR  myColumn.name = param1
   ;

这篇关于DB2条件WHERE子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！