Re: Insert into TEXT column

On Wed, 12 Aug 1998, Patrik =C5gren wrote: > I have Informix 7.2. > In regular SQL can you Insert a row into a TEXT column? I assume you mean DB-Access rather than a language with variables such as ESQL/C or I4GL? The difference is important because the answers are different! 1.=09DB-Access: =09NO. There are no TEXT or BYTE literals in SQL, so there is no way =09to get the data into the database other than via the LOAD =09statement. 2.=09ESQL/C etc: =09YES. You store the data (or information about the file where the =09data is) in a locator structure and then pass that as a host =09variable to the INSERT statement (which will contain one or more =09question marks -- placeholders for host variables). > I have a table with a TEXT column and are converting data from another > table and generating plain SQLs INSERT statement. When I try to run the > statement I get error -617. Can I somehow prefix the data. No, there's no prefixing mechanism, and there are no TEXT literals. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.59 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn