Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.