DB2 SQL z/OS - variable equivalent of a hex constant -

DB2 SQL z/OS - variable equivalent of a hex constant -

i'm trying extract info (using spufi) db2 table file, 1 of output fields converting decimal field same format cobol comp field. e.g. today's date (20141007) ..ëõ

the sql hex function converts 20141007 013353cf, , doing select of x'013353cf' gives me desired result, that's constant, i'm trying find equivalent function. inverse of hex function.

i've come across couple of suggestions using user defined functions. problem is, we've upgraded db2 10 , new function mode isn't enabled yet, means don't have access command functions in udf.

i suspect i'm out of luck, wondering if has suggestions. appreciate wrong tool job, , easier write cobol programme it, various constraints preventing that. i'm limited sql functions , perchance jcl).

i thought had solution using recursive udf around lack of command functions, that's not allowed either.

sql db2 hex zos