How do i convert DB2 return code from hex

karthi1 · New User Joined: 07 Jul 2006 Posts: 2 Location: Bangalore

How do i convert DB2 return code from hex...
eg.
how do i convert return code 80N ?

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi,
If my information is correct, DB2 operations returns SQL CODE ( SQLCODE OF SQLCA) in decimal formats.

However, there is a convertion possible from hexadecimal to decimal number system. Please google for conversion formula.

Thanks,
Parikshit

DavidatK · Posted: Sat Jul 08, 2006 2:56 am

Hi karthi1,

You are probably doing a 'DISPLAY SQLCODE' to get the 80N, right?

The 80N display in HEX is x'F8F0D5'. The 'D' is the sign indicator, in this case '-'.

Move the SQLCODE to something like WS_SQLCODE defined as PIC -999, then 'DISPLAY WS-SQLCODE'. You will get -805.

Dave