FILETOBLOB 
Author Message
 FILETOBLOB

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.
Quote:

> 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.



Wed, 18 Jun 1902 08:00:00 GMT
 FILETOBLOB

Quote:

> 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.


> > 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.

--

Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN
#include <disclaimer.h>



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

 
Powered by phpBB® Forum Software