Update TEXT with PERL?

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). Any ideas? PS: I would rather be using LVARCHAR in a 9.X flavor, but unfortunately they won't look at 9 as an option. -- Rob Wilson rwilson@ntsource.com

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

Douglas Wilson (dwilson@gtemail.net) wrote: : 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 Funny the way you can read a document 100 times and when you are told to read it the 101st (and you actually do) you notice that one little line :). Thanks. -- Rob Wilson rwilson@ntsource.com