zOs/SQL/EXPACK

declare global temporary table  session.p(p varbinary(1000));
insert into session.p values(
    pack(ccsid 1208, 'ein name', 123, 'und etwas mehr text'));
select unpack(p).*
          as (name char(16) ccsid unicode
             , num int, text varchar(30) ccsid unicode)
      , hex(p)
      , hex(cast('ein name' as char(10) ccsid unicode))
    from session.p
;
select unpack(p).*
          as (name char(16)
             , num int, text varchar(30) )
    from session.p