Re: Maybe LOB, BLOB, CLOB is for storing stream objects in a relational database

Eric,

I think perhaps you should look at datalinks...

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/sqlp/rbafydatalinks.htm

-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of elehti@xxxxxxxxxxxxxxxxxx
Sent: Tuesday, May 08, 2012 3:29 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Maybe LOB, BLOB, CLOB is for storing stream objects in a relational database

I will ask my IBM support team in Rochester.

Maybe LOB, BLOB, CLOB is for storing stream objects in a relational
database

Maybe the relational database I need is

DB2Clob Class

Represents the CLOB DB2 data


DB2Blob Class


Represents the BLOB DB2 data





http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2F
com.ibm.swg.im.dbclient.adonet.ref.doc%2Fdoc%2FIBMDataDB2TypesNamespace.
html



Does IBM i V7.1 DB2 have capability to store stream files (.pdf, .xls,
.doc, etc.) in a network folder and enable some program to retrieve
these in a manner similar to CHAIN or SETLL?

Suppose a network folder has hundreds, even thousands of .pdf documents.

Using Windows Explorer to open that folder will display all the files,
but viewing the folder becomes slower as the number of objects in the
folder increases.



What is the terminology IBM uses to describe storing binary objects in a
relational database?

I want a relational database for stream file objects with capability for
keys and indexes.

Eric