Hi,

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?

Thank's
Christophe

Try this
db2 "select ascii('c') from sysibm.sysdummy1"

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")

Bye
Christophe