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 子句中的过滤器应用.这可以在 DB2 中实现吗?

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屋！