A blob data type must be supplied within this context

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 fromTABLE_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.

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