var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Function ASCII() on DB2 Mvs v7
I'm using the function ASCII() on oracle database to convert a char on its ascii corresponding number. I want to use a similar function on DB2 but I can't arrive to find something equivalent.
Can someone help me?
db2 "select ascii('c') from sysibm.sysdummy1"
Originally Posted by
this function becomes available in DB2 V8 NFM
there is no equivalent function in DB2 V7. ( not even in DB2 V8 CM )
OK, thank you very much. I'll wait the upgrade of our system in few months...
(Nageswaran, I've tried your example, but DB2 replied :"SQL0440N No function by the name "ASCII " having compatible arguments was
found in the function path. SQLSTATE=42884")