Oninit cdi / Archive
Talk to an expert →

how to store a file in databes

Posted in 2009

Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues

eferreyra — — source: Usenet: comp.databases.informix

Hi peps. We have IDS 11.50 with no extra modules, hosted in unix-like OS (linux, solaris, aix, etc.) The clients are ODBC or .NET Data Provider from Windows OS. I need to store files from the clients to the BD (in some kind of BLOB i guess) and then of course the inverse way, read the file from DB and save it it client (print-it, etc.) In the db there is no need of process the file in any way, just store and then recover from/to clients. I need guidance on how to do this, the simple way the better. Remember ODBC or .NET data provider. Thanks guys.

↪ replying to eferreyra
Carsten Haese — — source: Usenet: comp.databases.informix

eferreyra wrote: > Hi peps. > > We have IDS 11.50 with no extra modules, hosted in unix-like OS > (linux, solaris, aix, etc.) > > The clients are ODBC or .NET Data Provider from Windows OS. > > I need to store files from the clients to the BD (in some kind of BLOB > i guess) and then of course the inverse way, read the file from DB and > save it it client (print-it, etc.) > > In the db there is no need of process the file in any way, just store > and then recover from/to clients. > > I need guidance on how to do this, the simple way the better. > > Remember ODBC or .NET data provider. You'll want to use the BLOB datatype. The SQL functions LOTOFILE and FILETOBLOB are your friends. For more information, see http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.odbc.doc/odbc102.htm HTH, -- Carsten Haese http://informixdb.sourceforge.net

↪ replying to Carsten Haese
Enrique Ferreyra (Pachu) — — source: Usenet: comp.databases.informix

Thanks! its working!. On 16 jun, 14:37, Carsten Haese <carsten.ha...@gmail.com> wrote: > eferreyra wrote: > > Hi peps. > > > We have IDS 11.50 with no extra modules, hosted in unix-like OS > > (linux, solaris, aix, etc.) > > > The clients are ODBC or .NET Data Provider from Windows OS. > > > I need to store files from the clients to the BD (in some kind of BLOB > > i guess) and then of course the inverse way, read the file from DB and > > save it it client (print-it, etc.) > > > In the db there is no need of process the file in any way, just store > > and then recover from/to clients. > > > I need guidance on how to do this, the simple way the better. > > > Remember ODBC or .NET data provider. > > You'll want to use the BLOB datatype. The SQL functions LOTOFILE and > FILETOBLOB are your friends. > > For more information, seehttp://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=... > > HTH, > > -- > Carsten Haesehttp://informixdb.sourceforge.net

Glossary