【求助】with语句应该怎么用~~~~

whvagrant

菜鸟刚开始学，想看看db2中with语句怎么用，查了一下，自己写写，发现总是报错，又不清楚为什么，特来求教

表结构 cc(c1 smallint, c2 varchar(10))

with temp_table(c1,c2) as (
select c1,c2 from cc
where c1=1
union all
select c.c1,c.c2 from temp_table t,cc c
where t.c1=c.c2-1)
select * from temp_table

Message: [IBM][CLI Driver][DB2/NT] SQL0420N  Invalid character found in a character string argument of the function "DECFLOAT".  SQLSTATE=22018

版本是db2 express-C 用的EMS sql manager for db2