A blob data type must be supplied within this context

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Massoroto - 26 May 2006 18:30 GMT

Hi,

I am working with Informix 7.31 and I would like to insert string data
into a TEXT field as follows:

insert into TABLE_DESTINY (TEXT_FIELD) select CHAR_FIELD from
TABLE_ORIGIN;

I get the message "A blob data type must be supplied within this
context ".

Is there any way I can do it? Any function that converts it? I am
defining a TEXT data type since I will obtain a chain of characters of
more than 32 Kb. Any other data type which may help me?

PS: There is no possibility neither to use load dbaccess command nor
onload or dbload.

Thany u.

Reply to this Message

Jonathan Leffler - 27 May 2006 04:50 GMT

> I am working with Informix 7.31 and I would like to insert string data
> into a TEXT field as follows:
[quoted text clipped - 11 lines]
> PS: There is no possibility neither to use load dbaccess command nor
> onload or dbload.

Not in IDS 7.31. In IDS 9.x or 10.x, you'd be in with a chance.

The only way that will work is to unload the data to a file and then
reload the data. Since you can't use most of the possible tools, you're
stuck with either dbexport and dbimport (clumsy) or SQLCMD (from the
IIUG software archive).

If those aren't options either, I suggest you talk to the powers-that-be
and explain that since they won't allow you to use the only solutions
that will work (onunload/onload won't help), then either they withdraw
the task or they provide you with the tools that will permit you to do it.

Signature

Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Reply to this Message