How to Handle BLOBs via ODBC ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eferreyra - 30 Oct 2006 12:34 GMT

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 ?

Reply to this Message

Marco Greco - 30 Oct 2006 12:46 GMT

> Hi, i need to store "files" (.doc, .pdf, etc.) in an informix database,
> the scenario is:
[quoted text clipped - 9 lines]
>
> 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...

Signature

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

Reply to this Message

eferreyra - 30 Oct 2006 13:20 GMT

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:

> > Hi, i need to store "files" (.doc, .pdf, etc.) in an informix database,
> > the scenario is:
[quoted text clipped - 32 lines]
> 4glworks http://www.4glworks.com
> Informix on Linux http://www.4glworks.com/ifmxlinux.htm

Reply to this Message

Jonathan Leffler - 31 Oct 2006 07:02 GMT

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

Signature

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

Reply to this Message