RE: How to Identify
From: Robert Stuart <Robert.Stuart@NFER-NELSON.co.uk>
>
>Yup - he wants it in the shell!
hexval=`dbaccess dbname <<! 2> /dev/null | grep "0x" | awk '{print $1}'
select hex(colname)
from table
where criteria
!
`
Or something like that?
>-----Original Message-----
>From: Obnoxio The Clown [mailto:obnoxio@hotmail.com]
>Sent: 22 November 2000 10:18
>To: JasonYLPang@pg.SLR.com; informix-list@iiug.org
>Subject: RE: How to Identify
>
>
>From: JasonYLPang@pg.SLR.com
> >
> >Hi Jack,
>
>Quick! Call the cops!!
>
> >Is there a formula to convert numeric to hex?
>
>Is this a trick question? hex()?
>
> >-----Original Message-----
> >From: Parker, Jack [mailto:JParker@engage.com]
> >Sent: Saturday, November 18, 2000 12:42 AM
> >To: Jagadish Jagadish; informix-list@iiug.org
> >Subject: RE: How to Identify
> >
> >
> >I have a lovely note from Mr. Avila some time back which explains all of
> >this - let me see if I can dig it up. (ah - I have it in hardcopy).
> >
> >Get the SERVERNUM from the ONCONFIG file
> >0x5256 + hex(SERVERNUM) yields the start of the key shown by ipcs.
> >
> >if SERVERNUM is 251, converted to hex that is FB
> >5256 + FB = 5351
> >
> >ipcs will report something like
> >
> >Share Memory .....
> >m 202 0x53514802 -rw-rw-rw- root informix
> >
> >Thanks Brice.
> >
> >cheers
> >j.
>
>[deleted]
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com