Why are you doing this as 'record at a time' processing in a stored procedure? This may be appropriate on older transaction-based DBMS, but not for Netezza.

Better to use standard SQL to do this processing in 'bulk mode'

D.

did you try something like below?

insert into t2
select t3.gen_key, t1.*
from t2 , t3
where t2.pk_1 =t3.pk_1
union all
select next value for s, t1.*
from t2 a
where not exists ( select 1 from t3 b where a.pk_1 = b.pk_1)

as you might notice, sequences behaviour is not identical to oracle sequences.