what version of IDS?
I not sure, but this is supported only after version 10 xC3...
in IDS 11.50 , this code works
Code:
create temp table a (coda int);
Temporary table created.
create temp table b (codb int);
Temporary table created.
insert into b values (1);
1 row(s) inserted.
insert into b values (2);
1 row(s) inserted.
insert into b values (3);
1 row(s) inserted.
insert into a (coda)
select first 1 * from b
1 row(s) inserted.
Database closed.