DB2的查询sql有关问题

2012-02-02

DB2的查询sql问题SELECT ORG1.ID AS COMPID,ORG2.ID AS ORGIDFROM APPUSER.OAMP_ORG_ORGANIZATION ORG1 ,

DB2的查询sql问题
SELECT ORG1.ID AS COMPID,ORG2.ID AS ORGID
FROM APPUSER.OAMP_ORG_ORGANIZATION ORG1 , OAMP_ORG_ORGANIZATION ORG2
WHERE ORG1.PARENTORGID = 1
AND ORG2.ORGPATH = '%'||RTRIM(LTRIM(CHAR(ORG2.ID)))||'%'

SQL报了下面的错误，请问如何解决呢？
[color=#FF0000]
19:32:08.843DBMSCMS -- Error: [IBM][CLI Driver][DB2/AIX64] SQL0132N LIKE 谓词或 POSSTR 标量函数无效，因为第一操作数不是字符串表达式或第二操作数不是字符串。 SQLSTATE=42824[/color]

[解决办法]
加%是为了使用like吧？
AND ORG2.ORGPATH like '%'||RTRIM(LTRIM(CHAR(ORG2.ID)))||'%'
[解决办法]
AND ORG2.ORGPATH = '%'||RTRIM(LTRIM(CHAR(ORG2.ID)))||'%'

PATH 看名称好象是个路径,%s??
[解决办法]

SQL code

SELECT ORG1.ID AS COMPID,ORG2.ID AS ORGIDFROM APPUSER.OAMP_ORG_ORGANIZATION ORG1 , OAMP_ORG_ORGANIZATION ORG2WHERE ORG1.PARENTORGID = 1AND LOCATE (RTRIM(LTRIM(CHAR(ORG2.ID))),ORG2.ORGPATH)>0
[解决办法]
% 要用转义吧，我猜测。不知道你想搜索什么，条件是什么。

热点排行

IBM DB2

DB2的查询sql有关问题