当前位置: 代码迷 >> DB2 >> DB2 select 报22001异常
  详细解决方案

DB2 select 报22001异常

热度:3708   发布时间:2013-02-26 00:00:00.0
DB2 select 报22001错误
SQL code
WITH t1(u,o,num) AS (    SELECT user_id,organ_id,row_number() over(PARTITION BY user_id ORDER BY organ_id) FROM V_ORGAN_USER_INFO),t2(au,ao,anum) AS (    SELECT u,o,num FROM t1 WHERE num=1    UNION ALL    SELECT t1.u,t2.ao||','||t1.o,t1.num FROM t1,t2     WHERE t1.num=t2.anum+1 AND t1.u=t2.au [color=#FF0000]AND t1.num <3[/color])SELECT au,ao FROM t2WHERE aNUM = (SELECT max(anum) FROM t2 temp WHERE temp.au=t2.au)ORDER BY t2.au;


这是一个DB2列转行的SQL,在查询的时候报 值太长,22001错误
当加上限制行数的参数AND t1.num <3就不会报错了,谁知道是怎么回事?

------解决方案--------------------------------------------------------
没有加 t1.num <3,你的代码就会无限递归
  相关解决方案