zOs/SQL/CASTUNI

with v1(v) as
(           select 'abc123' from sysibm.sysDummyE
  union all select 'abc@123' from sysibm.sysDummyE
  union all select '@abc@123' from sysibm.sysDummyE
)
, v as
(
    select cast(v as varchar(12) ccsid ebcdic) v from v1
)
select v "ebcdic",
       cast(v as varchar(12) ccsid unicode)   unicode,
       hex(cast(v as varchar(12) ccsid unicode))  "unicodeHex"
    from v
;;
select
            cast('@abc@123' as varchar(10) ccsid ebcdic) ebcdic,
        hex(cast('@abc@123' as varchar(10) ccsid ebcdic))ebcHex,
       cast(
            cast('@abc@123' as varchar(10) ccsid ebcdic)
                          as varchar(10) ccsid unicode)   unicode,
  hex( cast(
            cast('@abc@123' as varchar(10) ccsid ebcdic)
                          as varchar(10) ccsid unicode) ) unicoHex,

       cast(
            cast('@abc@123' as varchar(10) ccsid ebcdic)
                          as varchar(10) ccsid unicode for bit data)
           uniBit
    from sysibm.sysDummy1
;
     cast(
       cast(
            cast('@abc@123' as varchar(10) ccsid ebcdic)
                          as varchar(10) ccsid unicode)
                          as varBinary(10) )
           uniBinary,
   cast(
     cast(
       cast(
            cast('@abc@123' as varchar(10) ccsid ebcdic)
                          as varchar(10) ccsid unicode)
                          as varBinary(10) )
                          as varchar(10) ccsid ebcdic )
           uniBinary