FILETOBLOB

I use Informix On-Line server v 7.1 for Unix SCO. I try to do this query from dbaccess update informix.provaandrea set img=FILETOBLOB('/usr/file','server') where campo1='PSQL' the response is: 674: Routine (filetoblob) can not be resolved. Why it can't find the function 'Filetoblob'? I have to install some componects? Thank Andrea Note:the field img is a blob.

The FILETOBLOB is used to populate a blob. v7.1 has a byte data type which is just a bit different than a blob data type. If you look in the $INFORMIXDIR/demo directory, I think that there is a demo program that can be used to load a byte field from a file. Menozzi wrote: > I use Informix On-Line server v 7.1 for Unix SCO. > I try to do this query from dbaccess > > update informix.provaandrea set img=FILETOBLOB('/usr/file','server') > where campo1='PSQL' > > the response is: > 674: Routine (filetoblob) can not be resolved.> > Why it can't find the function 'Filetoblob'? > I have to install some componects? > > Thank > > Andrea > > Note:the field img is a blob.

Madison Pruet wrote: > The FILETOBLOB is used to populate a blob. v7.1 has a byte data type > which is just a bit different than a blob data type. If you look in the > $INFORMIXDIR/demo directory, I think that there is a demo program that > can be used to load a byte field from a file. > > Menozzi wrote: > > > I use Informix On-Line server v 7.1 for Unix SCO. > > I try to do this query from dbaccess > > > > update informix.provaandrea set img=FILETOBLOB('/usr/file','server') > > where campo1='PSQL' > > > > the response is: > > 674: Routine (filetoblob) can not be resolved.> > > > Why it can't find the function 'Filetoblob'? > > I have to install some componects? Hi, The FILETOBLOB routine is only available in 9.x servers. So one option is to upgrade from 7.1 (which is *not* Y2K compliant) to IDS.2000. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>