[求助]公共表达式产生的值怎么存入到表中

drwine

使用with写了一个递归语句，能产生正确的值。

with aaa (...) as (

.......

)
select * from aaa

此语句执行成功，可是我想将结果保存到表中：
with aaa (...) as (

.......

)
insert into bbb
select * from aaa

却报Expected tokens may include "from"，我想也许DB2不支持这种写法，于是：

insert into bbb select * from (
with aaa (...) as (

.......

)select * from aaa
)
却报An unexpected token "as" was found ....

但在oracle中上，这种用法是可以的。难道db2的with语句产生的结果只能看看，不能存表?求高人指点。

Germin

try

insert into bbb
with aaa (...) as (

.......

)select * from aaa