Oninit cdi / Archive
Talk to an expert →

Newbie BLOB question

Posted in 2006

Summary

A first-time poster (debbie) wanted to store PDF files in Informix Dynamic Server 10 on Linux and asked about best practice. Obnoxio The Clown said to use a blobspace or a BYTE column and pointed to the documentation on populating it. Adam Tauno Williams showed a CREATE TABLE with a BYTE column IN a blobspace and said they store PDFs this way. The poster still asked for the load/retrieve syntax; no answer followed.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Data Types & Schema Design

debbie@diversifiedmetals.com — — source: Usenet: comp.databases.informix

Hi all - first time post-ee here. I need to store .pdf files in Informix (Dynamic Server 10 on Linux) After days of futile research I am still unsure which direction to take. What is the "best practice" method for storing large objects in Informix? Should I setup and use a blobspace? Can a byte data type column be used? If so, how do you populate it? Any insight is appreciated! Thanks.

↪ replying to debbie@diversifiedmetals.com
Obnoxio The Clown — — source: Usenet: comp.databases.informix

debbie@diversifiedmetals.com said: > Hi all - first time post-ee here. > > I need to store .pdf files in Informix (Dynamic Server 10 on Linux) > After days of futile research I am still unsure which direction to > take. What is the "best practice" method for storing large objects in > Informix? Should I setup and use a blobspace? Can a byte data type > column be used? If so, how do you populate it? > > Any insight is appreciated! Warning: I'm drunk. 1. You could use a BLOBspace. 2. You could use a BYTE column. 3. You can see ways of populating it here: http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlr.doc/sqlrmst101.htm#sii-02-39286 Maybe you should try drinking. This took me two minutes to find. -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to debbie@diversifiedmetals.com
Adam Tauno Williams — — source: Usenet: comp.databases.informix

On Fri, 2006-11-17 at 11:02 -0800, debbie@diversifiedmetals.com wrote: > Hi all - first time post-ee here. > > I need to store .pdf files in Informix (Dynamic Server 10 on Linux) > After days of futile research I am still unsure which direction to > take. What is the "best practice" method for storing large objects in > Informix? Should I setup and use a blobspace? Yes > Can a byte data type column be used? Yes Just like - CREATE TABLE foo ( normal_field_1 INT, normal_field_2 CHAR(12), blob_field BYTE IN blobspace ) IN tablespace; > If so, how do you populate it? ? Via SQL? We have a large blobpace in Informix on Linux used to store PDFs.

↪ replying to Adam Tauno Williams
debbie@diversifiedmetals.com — — source: Usenet: comp.databases.informix

Thank you, Adam. I'm no DBA so please bear with me. > > If so, how do you populate it? > > ? Via SQL? I figured, but I'm not clear on the syntax....what do you use to populate and retrieve? (load, unload, what is filetoblob?..etc..) Thanks, again!

Related threads

Glossary