I beg to differ.
A 32 bit unsigned integer will have values from 0 to 4294967295.
A signed 32 bit integer (1's complement) will vary from -2147483648 to
2147483647
In both cases 10 digits maximum or 9 digits if the MSD should vary from 0 to 9.
Best regards
"Art S. Kagel" wrote:
>
> nguffey@jdriscoll.com wrote:
> >
> > Does anyone know how informix (7.30.TC3) generates the sessionid? I know from
> > sysmaster.sql that it is an int, but i need to have some sort of understanding
> > of where the value comes from. Is it tied to some memory address, is it
> > randomly generated based on some algorithm, etc...
> >
> > Our app creates sp's dynamically and wants to use sessionid as part of the
> > naming convention so that they can be tied to the session that created them.
> > Since informix 7.3 only allows 18 characters for identifiers, we need to
> > know, within reason, what lengths to expect from the sessionid. I've only
> > seen lengths of 8-10 characters, but then ours is a development system and
> > not under heavy usage. Any help would be greatly appreciated...
>
> Well since it is a 32bit integer it cannot exceed 13 digits!
>
> Art S. Kagel
--
Erik Zetterberg | An expert knows more and more about
A.C.E. Air Cargo Express AB | less and less and ultimately knows
Box 18, SE-19045 Stockholm-Arlanda, Sweden| everything about nothing.
T: +46 87978942 F: +46 87978902 | I'm going in the opposite direction
↪ replying to Erik Zetterberg
Erik Zetterberg wrote:
>
> I beg to differ.
> A 32 bit unsigned integer will have values from 0 to 4294967295.
> A signed 32 bit integer (1's complement) will vary from -2147483648 to
> 2147483647
> In both cases 10 digits maximum or 9 digits if the MSD should vary from 0 to 9.
Of course. That is what I get for counting the digits in my head at
the end of the day. Thanks for keeping me honest.
Art S. Kagel