Long Type

Posted in 1999

Irineu Rocha — Wed, 1 Dec 1999 17:06:07 -0300 — source: Informix-list mailing list archive (1991-1998)

Hi folks, Does anybody know how to build a select with a clause where on a attribute defined as long? SISGRAPH Irineu Tachinardi Rocha AIM Group - Sisgraph (Intergraph Brazil) Senior System Analyst Email: irineu@sisgraph.com.br Phone: 55-11-8892058 Fax: 55-11-8877763 http://www.sisgraph.com.br

↪ replying to Irineu Rocha

Jonathan Leffler — Thu, 02 Dec 1999 05:41:53 -0800 — source: Informix-list mailing list archive (1991-1998)

Irineu Rocha wrote: > Does anybody know how to build a select with a clause where on a attribute > defined as long? LONG isn't an Informix data type; it is used in Oracle, where it approximates to an Informix byte/text blob. If you're processing a text blob, you can write a search criterion on a fixed substring: WHERE textfield[1,12] = "My Criterion" -- unless my counting is askew You can do nothing with a BYTE blob as far as I know. You may have more options if you're using IUS (IDS/UDO, Foundation.2000) smart large objects -- aka slobs -- the BLOB and CLOB types. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>