declare c1 cursor with return for select * from session.T_PEOPLE;
...
declare global temporary table session.T_PEOPLE as
(select * from db2alex.T_PEOPLE where date_born = '1975-09-05')
definition only with replace:

insert into session.T_PEOPLE
select * from db2alex.T_PEOPLE where date_born = '1975-09-05';
GET DIAGNOSTICS rows_count = ROW_COUNT;
open c1;

declare c1 cursor with return for 
with t as (select * from db2alex.T_PEOPLE where date_born = '1975-09-05')
select t.*, (select count( 1 ) from t) rows_count
from t;