Re: UPDATEBLOB

On Wed, 2 Dec 1998, Steven Primrose-Smith wrote: > I need to update a blob in an informix database using perl and dbi. > Looking through old messages posted here, some say it's not possible Indeed; the 'perldoc DBD::Informix' file also says this, does it not? > and so say use UPDATEBLOB. What is the syntax for using > UPDATEBLOB, if indeed it works? If that's the UPDBLOB program, then the information is in the man pages that come with it. updblob -d dbase -t table -k colname=value [ -k colname=value] \\ -c blobcol [-f] blobfile Basically, database name, table name, primary key column names and values, the blob column name and the file containing the new value for the blob. It works for me, but then I wrote it so I don't have any major problems working out how to get it to do what I want. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn