QUESTION POSED ON: 24 February 2009
Can I insert data from a CTE into a file? I have this query:
with recursive appidrange ( start, end) as
(select 4500000, max(apptid) from coprddb3/corcvaptp),
allIds (apptidlist, endid) as
( select start as apptidlist, end as endid
from appidrange union all
select existing_row.apptidlist + 1
existing_row.endid
from allIds existing_row
where existing_row.apptidlist +1 <= existing_row.endid),
missingIds as (
select apptidlist from allids
except
select apptid from coprddb3/corcvaptp as temp)
insert into jgriffin/apptids
select * from missingIds;
As a result of this query, I get an SQL code of: -199 Insert not expected. How can I do this?
|
