Re: Function for nth bit set?

On Mon, 19 Apr 2004 07:02:44 -0400, Dirk Gunsth'''vel wrote: There's a stored procedure for bit checking and setting. Check out the procedure sysmaster:bitval. It's used in some of the other SPL and in some VIEWs in sysmaster so you can see how it is working. Art S. Kagel > Hi, folks :-) > > I wonder if there is an easy way in Informix SQL/SPL to ask if the nth bit > of lets say an Integer is set. > > Something like the & operator in Java? > > Thanks in advance, > Dirk > > -- > -- > -- Dirk Gunsthoevel IT Systemanalyse phone: +49 (0)251 28446-0 -- Hammer > Str. 13 fax: +49 (0)251 28446-55 -- D-48153 Muenster > http://www.GunCon.de/ -- "The cost of living hasn't > affected its popularity."

> There's a stored procedure for bit checking and setting. Check out the > procedure sysmaster:bitval. It's used in some of the other SPL and in some > VIEWs in sysmaster so you can see how it is working. > > Art S. Kagel > That was exactly what I was looking for. Thanks, Dirk -- -- Dirk Gunsthoevel IT Systemanalyse phone: +49 (0)251 28446-0 -- Hammer Str. 13 fax: +49 (0)251 28446-55 -- D-48153 Muenster http://www.GunCon.de/ -- "The cost of living hasn't affected its popularity."