declare global temporary table session.tDGT as 00001006
( select * from A540769.tPer08 00002006
) with no data 00003006
on commit delete rows 00004006
; 00005006
select current timestamp from sysibm.sysdummy1 00006006
; 00007006
insert into session.tDGT 00008006
select * from A540769.tPer08 fetch first 10 rows only 00009007
; 00010006
select current timestamp from sysibm.sysdummy1 00130001
; 00131003
insert into session.tDGT 00132007
select * from A540769.tPer08 fetch first 100 rows only 00133007
; 00134007
select current timestamp from sysibm.sysdummy1 00135007
; 00136007
insert into session.tDGT 00137007
select * from A540769.tPer08 fetch first 1000 rows only 00138007
; 00139007
select current timestamp from sysibm.sysdummy1 00139107
; 00139207
select count(*) from session.tDgt 00140001
; 00141003
select current timestamp from sysibm.sysdummy1 00150001