select c1, hex(rid(t))
from QZ92CRT.TQZ91M2UTSA t
order by c1 desc
fetch first 30 rows only
;x;
insert into QZ92CRT.TQZ91M2UTSA (c1,c2)
with i(i) as
(
select 0 from sysibm.sysDummy1
union all select i+1 from i where i < 32000
)
select 'B' || i, 'Bb'|| i
from i