Re: Update TEXT with PERL?

Posted in 1999

Mario R. Canto — Wed, 08 Sep 1999 09:39:17 -0300 — source: Informix-list mailing list archive (1991-1998)

You can LOAD text in a temp table, then UPDATE your tablewithtext SET yourtextcolumn = (SELECT textdata FROM tmptable WHERE condition) WHERE conditionfortheupdate Douglas Wilson escribis: > > On Tue, 07 Sep 1999 20:09:36 GMT, rwilson@ntsource.com (Rob Wilson) wrote: > > >Can anyone recommend a method to update a TEXT field using PERL? I > >have tried update test set col2 = ? where col1 = ?; which I knew > >wouldn't work (according to documentation of TEXT data type). > > What sort of perl library are you using? If its DBI/DBD, then I believe > the DBD::Informix documentation says that you can't update, that you > have to delete the old and insert a new record. (Check it out yourself > to confirm this). > > Good Luck, > Douglas Wilson Byte byte! -- Mario R. Canto mcanto@intec.unl.edu.ar mcanto@intec.arcride.edu.ar http://www.intec.unl.edu.ar/~mcanto