Re: bit map in integer type and MSB issue

Not an option. I have to resolve this issue without ESQL/C or C in general. Both Unix systems are sort of dedicated workstations without any development or GNU stuff on. If nothing else works, I will have to unload respective collumns, modify them using unix utilities (awk) and load them back in. Thanks anyway. Regards, George In article <380DFD41.2BF59D45@bloomberg.net>, kagel@bloomberg.net wrote: > ESQL/C. Get the SDK and write a small ESQL program to do this. > > Art S. Kagel > > vicherj@my-deja.com wrote: > > > > I have a set of columns of type integer which holds a bit map. > > While copying data from Informix 5.02 on SCO Unix ODT 3.0 to Informix > > 7.2 on Sun Sparc using unload to / load from statements this bit map got > > all screwed - I suspect little and big endian issues got in the way. > > > > Now I need to write a procedure to swap the bytes in an integer field, > > but I have trouble with the sign bit. When loading from an ASCII file, > > empty field ("||") means just the sign bit set, while 0 ("|0|") means no > > bits set. The rest of the bits have their weight representation. > > > > How do I set the sign bit alone from within a stored procedure? > > > > Thanks for any ideas > > > > George > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.