Binary Operators

Posted in 2006

Jairo Gubler — Wed, 18 Oct 2006 12:01:47 — source: IIUG Forums & Mailing Lists

Our developers need binary operations (and / or) on INFORMIX SQL. Has INFORMIX native binary operators or functions ? Jairo Gubler

↪ replying to Jairo Gubler

Marco Greco — Wed, 18 Oct 2006 12:31:58 — source: IIUG Forums & Mailing Lists

Jairo Gubler wrote: > Our developers need binary operations (and / or) on INFORMIX SQL. > Has INFORMIX native binary operators or functions ? > > Jairo Gubler > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Please qualify what you mean by INFORMIX SQL - is the legacy tools product that you are talking about, or the specific SQL dialect understood by Informix Dynamic Server, or, for that matter, Informix Standard Engine? Also version info would not be bad... -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm

↪ replying to Marco Greco

Jairo Gubler — Wed, 18 Oct 2006 12:59:10 — source: IIUG Forums & Mailing Lists

INFORMIX SQL Language for IDS 9.40. Something like: SELECT * FROM table WHERE column & 1 = 1 Marco Greco escreveu: Jairo Gubler wrote: Our developers need binary operations (and / or) on INFORMIX SQL. Has INFORMIX native binary operators or functions ? Jairo Gubler ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. Please qualify what you mean by INFORMIX SQL - is the legacy tools product that you are talking about, or the specific SQL dialect understood by Informix Dynamic Server, or, for that matter, Informix Standard Engine? Also version info would not be bad... -- Jairo Gubler Supervisor SIC - TBD - Tecnologia em Banco de Dados DÍGITRO TECNOLOGIA E-mail: [1]jairo.gubler@digitro.com.br Fone: +55 48 3281-7213 / +55 48 3281-7000 Fax: +55 48 3281-7381 / +55 48 3281-7299 Site: [2]www.digitro.com References 1. mailto:jairo.gubler@digitro.com.br 2. http://www.digitro.com/

↪ replying to Jairo Gubler

Jonathan Leffler — Tue, 24 Oct 2006 14:02:40 — source: IIUG Forums & Mailing Lists

>> Jairo Gubler wrote: >>> Our developers need binary operations (and / or) on INFORMIX SQL. >>> Has INFORMIX native binary operators or functions ? > Marco Greco escreveu: >> Please qualify what you mean by INFORMIX SQL - is the legacy tools product >> that you are talking about, or the specific SQL dialect understood by Informix >> Dynamic Server, or, for that matter, Informix Standard Engine? >> >> Also version info would not be bad... Jairo Gubler wrote: > INFORMIX SQL Language for IDS 9.40. It's a little complicated, and well and truly tied up with history, but there is a product called Informix-SQL which is separate from the Informix dialect of SQL supported by Informix Dynamic Server (and the other dialects supported by XPS and SE). ISQL is at version 7.32. What you're referring to is IDS 9.40. (And yes, there are banners frm IDS tools that refer to Informix SQL that are part of IDS and not of ISQL - just compounding the confusion.) > Something like: > > SELECT * > FROM table > WHERE column & 1 = 1 Those functions are not built into IDS. You can see whether you can find BIT_AND(), BIT_OR() and similar functions - there are various implementations around, IIRC. The fastest ones would be in a diminutive data blade (a set of C code UDRs). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler

paul — Tue, 24 Oct 2006 14:13:04 — source: IIUG Forums & Mailing Lists

Try http://www.oninit.com/reference/index.php?page=bitval.html They might do what you want Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend IDUG 2007 San Jose, North America May 6-10, 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of Jonathan Leffler > Sent: 24 October 2006 09:03 > To: ids@iiug.org > Subject: Re: Binary Operators [7667] > > > >> Jairo Gubler wrote: > >>> Our developers need binary operations (and / or) on INFORMIX SQL. > >>> Has INFORMIX native binary operators or functions ? > > > Marco Greco escreveu: > >> Please qualify what you mean by INFORMIX SQL - is the legacy tools > >> product that you are talking about, or the specific SQL dialect > >> understood > by Informix > >> Dynamic Server, or, for that matter, Informix Standard Engine? > >> > >> Also version info would not be bad... > > Jairo Gubler wrote: > > INFORMIX SQL Language for IDS 9.40. > > It's a little complicated, and well and truly tied up with > history, but there is a product called Informix-SQL which is > separate from the Informix dialect of SQL supported by > Informix Dynamic Server (and the other dialects supported by > XPS and SE). ISQL is at version 7.32. > What you're referring to is IDS 9.40. (And yes, there are > banners frm IDS tools that refer to Informix SQL that are > part of IDS and not of ISQL - just compounding the confusion.) > > > Something like: > > > > SELECT * > > FROM table > > WHERE column & 1 = 1> > Those functions are not built into IDS. You can see whether > you can find BIT_AND(), BIT_OR() and similar functions - > there are various implementations around, IIRC. The fastest > ones would be in a diminutive data blade (a set of C code UDRs). > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian > of DBD::Informix v2005.02 -- http://dbi.perl.org/ > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the > discussion forum.