Re: how is sessionid generated

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

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