Oninit cdi / Archive
Talk to an expert →

storing pdf's in database

Posted in 2008

Topics: Storage & Space Management, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL

Floyd Wellershaus — — source: Usenet: comp.databases.informix

We have IDS10.0FC5 on Aix5.3. Is there a best recommended method for storing and retrieving pdf files to the database, that would be put there through an odbc connection coming from powerbuilder ? I am thinking a clob or blob in an sbspace that would be accessed via esqlc. As an alternative, is there a datablade that would allow the file to be stored on the unix OS with the pointer existing in the database ? Thanks much, Floyd

↪ replying to Floyd Wellershaus
Paul Watson (Oninit) — — source: Usenet: comp.databases.informix

Floyd Wellershaus wrote: > We have IDS10.0FC5 on Aix5.3. > > Is there a best recommended method for storing and retrieving pdf files > to the database, that would be put there through an odbc connection > coming from powerbuilder ? > > I am thinking a clob or blob in an sbspace that would be accessed via esqlc. > > As an alternative, is there a datablade that would allow the file to be > stored on the unix OS with the pointer existing in the database ? > > Thanks much, > Floyd > > I used to use the ETX blade for this. But the actual PDFs were stored on the filesystem, only the indices where stored in the database. The ETX blade is very good on PDFs

Glossary