Hi, i need to store "files" (.doc, .pdf, etc.) in an informix database,
the scenario is:

production enviroment: IBM Informix Dynamic Server Version 7.31.FD8 on
SunOS 5.9
development enviroment: IBM Informix Dynamic Server Version 9.40.UC7 on
Red Hat Enterprise Linux 2.6.9-5.ELsmp

Applications acces via ODBC to this databases, i try send FILETOBLOB
function but always get an "Not implemented yet" message, via JDBC
works, but is not an option (applications are Clarion 5.0 made)

Some suggestion ?

eferreyra wrote:
> Hi, i need to store "files" (.doc, .pdf, etc.) in an informix database,
> the scenario is:
>
> production enviroment: IBM Informix Dynamic Server Version 7.31.FD8 on
> SunOS 5.9
> development enviroment: IBM Informix Dynamic Server Version 9.40.UC7 on
> Red Hat Enterprise Linux 2.6.9-5.ELsmp
>
> Applications acces via ODBC to this databases, i try send FILETOBLOB
> function but always get an "Not implemented yet" message, via JDBC
> works, but is not an option (applications are Clarion 5.0 made)
>
> Some suggestion ?

Well, although I'm sure you are getting the -999 on your development
environment, and thus the next comment does not apply (yet), I thought I'd
save you a considerable amount of wasted time anyhow - smartblobs are not a
feature of 7.

In general it is a good idea to have development, test and production
environment on at least comparable versions.

As for the -999 on ODBC vs no error on JDBC, I'd say that the argument list
you are passing to FILETOBLB differs in the two cases, but it's hard to point
you in the right direction without seeing some hard SQL. Not that I'm asking
to see some, if you see what I mean...


--
Ciao,
Marco
__________________________________________________ ____________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

ok, thats why i put the ids 7 version in the mail.

Now how i can handle the storing of files in IDS 7 via ODBC ?

Or should i use other DBMS ?

E. Ferreyra


Marco Greco ha escrito:

> eferreyra wrote:
> > Hi, i need to store "files" (.doc, .pdf, etc.) in an informix database,
> > the scenario is:
> >
> > production enviroment: IBM Informix Dynamic Server Version 7.31.FD8 on
> > SunOS 5.9
> > development enviroment: IBM Informix Dynamic Server Version 9.40.UC7 on
> > Red Hat Enterprise Linux 2.6.9-5.ELsmp
> >
> > Applications acces via ODBC to this databases, i try send FILETOBLOB
> > function but always get an "Not implemented yet" message, via JDBC
> > works, but is not an option (applications are Clarion 5.0 made)
> >
> > Some suggestion ?
>
> Well, although I'm sure you are getting the -999 on your development
> environment, and thus the next comment does not apply (yet), I thought I'd
> save you a considerable amount of wasted time anyhow - smartblobs are not a
> feature of 7.
>
> In general it is a good idea to have development, test and production
> environment on at least comparable versions.
>
> As for the -999 on ODBC vs no error on JDBC, I'd say that the argument list
> you are passing to FILETOBLB differs in the two cases, but it's hard to point
> you in the right direction without seeing some hard SQL. Not that I'm asking
> to see some, if you see what I mean...
>
>
> --
> Ciao,
> Marco
> __________________________________________________ ____________________________
> Marco Greco /UK /IBM Standard disclaimers apply!
>
> Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
> 4glworks http://www.4glworks.com
> Informix on Linux http://www.4glworks.com/ifmxlinux.htm

eferreyra wrote:
> ok, thats why i put the ids 7 version in the mail.
>
> Now how i can handle the storing of files in IDS 7 via ODBC ?

Use BYTE blobs instead. Informix's ODBC should handle them; it
pre-dates version 9 of IDS (IUS).

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/