Hi,



You can use the SQL hex() function like in:



select hex(float4(session_id)) ...



Regards.



Leandro Fava

Setor de Informática - UNISC

+55 51 3717 7636



From: openroad-users-bounces (AT) peerlessit (DOT) com [mailtopenroad-users-bounces (AT) peerlessit (DOT) com] On Behalf Of hans.weisenberger (AT) mmm (DOT) com
Sent: sexta-feira, 5 de dezembro de 2008 12:32
To: International OpenROAD Users
Subject: [Openroad-users] session id in IPM and IMA




Hi all,

when I look at ipm I see the session_id displayed as Hexadecimal value, e.g. 80000001039de200.
If I look at the value in IMA I see 0009223372041210421760. If I put the in an calculator and switch
between hex and int thevalues are correct interpreted.

Is there any function in OR what does the right conversion? Or is there a column in IMA, that displays
the hex value?

Thanks in advance
Hans Weisenberger

In a related topic, if you want to make OpenROAD (or any client)
sessions identifiably in IPM (or vdba). Consider using session descriptions:

set session with description ='my application, user fred at my
computer (ip 1.1.1.1)'

It is a free format varchar, you can put anything you want in there.

Chris


Leandro Pinto Fava wrote:

Chris Clark wrote:

Yes! Also useful for tracing the progress of long-running jobs by
updating the session description as it progresses.

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.