Ggf. musst du das nochmal schachteln:

create table qtemp/DATEI as(
with a as (select ... from ...
where ... ),
b as (select ... from ...
where ... )
select * from (
select ... from ... where ...
fetch first 1000 rows only
) c
) with data