RE: insert TEXT type

Thanks, what I needed to do was a simple load. I've got it working now that I've got the docs in front of me (-: -- Jesse On Thu, 5 Feb 1998, Leffler, Jonathan wrote: > > > ---------- > From: Jesse Beveridge[SMTP:rastaman@primenet.com] > Sent: Wednesday, February 04, 1998 8:50 PM > > I have left my docs at work and am stuck right now attempting to > insert a sizable chunk of text into a table with a TEXT type column. > I know that: > > insert into table (text_col) > values ('string longer then 256 will not work')> > won't work. > > Can some please tell me the syntax for a sql statement that will > insert into a text type column.> > JL: It isn't clear from your message which language you are using. If you're playing > with DB-Access, the only statement that will work is a LOAD statement, and you need > the data in the file formatted correctly. If you are using ESQL/C or I4GL, then you > need to create a loc_t or TEXT variable which is initialized appropriately and then > use this in the VALUES list - or, in I4GL, use the LOAD statement again. > > There isn't a way to specify a blob (TEXT or BYTE) literal in (Informix's dialect of) SQL. > > Yours, > Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> >