zOs/SQL/DATA1

with l (l) as
(
  select 0 from sysibm.sysDummy1
  union all select l+1 from l where l < 10
)
select l, rand(), rand(1), rand(3456), rand(98745)
    from l
;
with l (l) as
(
  select 0 from sysibm.sysDummy1
  union all select l+1 from l where l < 20
)
select l, rand(), rand(1), rand(3456), rand(98745)
    from l
;X;














select sum(bigInt(length(t))), count(*)
    from t2