Re: Bitwise operators on Informix DB

Posted in 1998

Darin Tracy — Thu, 17 Dec 1998 09:22:26 +0000 — source: Informix-list mailing list archive (1991-1998)

Take a look at the bitval SPL in sysmaster. This spl will do the job for you.. dtracy Lucabond wrote: > > I have to perform a bitwise comparison (and) between two integer numbers > inside a SQL query on a Informix DB (ver. 5.01 and 7.1), SO HP-UX 9.04. I > would appreciate help, because the system doesn't accept these kinds of > statement: > > select count(*) from table where (field1 and integer) <> 0> <syntax error> > select count(*) from table where (field1 & integer) <> 0 <illegal> character> > > Regards > > Lucabond