zOs/SQL/EXROWNUM

with r as
(
select row_number() over (partition by left(dbName, 1)
                          order by creator, name desc) rn
       , strip(creator) || '.' || name crNm
       , t.*
    from sysibm.systables t
)
select *
    from r
    where 1 = rn