zOs/SQL/EXUNICOD

with u (a, b, c) as
(
  select ibmReqd, 'abc', 'efghij' from sysibm.sysDummyU
 union all  select ibmReqd, 'ABC', 'EFGHIJ' from sysibm.sysDummyU
)
select * from u;
select a, cast(cast(b as char(3) ccsid ebcdic)
        , cast(c as char(6) ccsid ebcdic)
        , a
     from u