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

[Gqcy <gmufasa01@xxxxxxxxx>]

cool,
have people used this to link DB2 for i to links on a windows network???


On 5/8/2012 3:53 PM, DeLong, Eric wrote:
> 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