Hex function on 64-bit addresses

DS 10.00.FC0 HP-UX b.11 64-bit IDS and OS Greetings, family. I am trying to write some bizarre SQL (would I write any other kind? ;-) on sysmaster. One of the columns is an address that would appear in the output of "onstat -b", if I have understood it correctly. In onstat -b the output appears correct, whereas in SQL it comes up as a negative number. This makes me suspect that onstat, written in C, is interpreting the addresses as unsigned while the SQL engine sees it as signed and it comes up as negative. The hex addresses that show up in onstat -b all start with c00000 before the other hex digits so it *would* look like a negative number. So, I tried to use the hex function: select hex(bh.address) ... from sysbufhdr bh ... (Yeah, I know it is not a documented SMI table; tha's never stopped me before. ;-) It runs a few seconds, then I get: Error 1284: Value will not fit into int8 (I briefly thought of using the abs() function for the negative numbers but that would be SOOooo wrong as an address!) As it happens, the address is not an essential part of the query; I want it there at first so I can compare the query results to the onstat output. Then I would have removed it. So this is a minor annoyance. Still, anyone have a workaround for that annoyance? Thanks much. -- J