JPLamontre
0 pts. | Sep 16 2005 4:05PM GMT
the answer is mainly in the question : a BLOB (binary Large Object) is a type of SQL column. So the best way to store or retrieve is a SQL call.
Direct call or stored procedure depending on your architecture, or if not, on samples you will find.
And storage of BLOB inside the database or outside (ie if IFS) also : depends of your architecture or found samples.
some month ago I have read some docs on BLOBs but don’t remember where I found it.
Look at ibm infocenter (SQL Reference InfoCenterinfodb2rbafzmst.pdf), or in search400 or on the web.
TomLiotta
7315 pts. | Nov 9 2009 7:18AM GMT
I agree that the ‘answer is in the question’. If it’s a BLOB, then it’s already in the native file system. Otherwise it’s not a BLOB — it’s a streamfile.
Tom






