I think this section from the web page URL given below is a good summary of
the advantage of a DataLink vs. a URL as column data. It can provide some
degree of management over the linked-to object.

<from_the_manual>
Using DataLinks also gives control over the objects while they are in
"linked" status. A DataLink column can be created such that the referenced
object cannot be deleted, moved, or renamed while there is a row in the SQL
table that references that object. This object are considered linked. Once
the row containing that reference is deleted, the object is unlinked. To
understand this concept fully, one should know the levels of control that
can be specified when creating a DataLink column.
</from_the_manual>

Craig Pelkie

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

As I had understood the DataLinks from a cursory review way back when,
without Link Control via the DLFM, there seemed to be little obvious value
for using them to store references to external files as compared with just
storing the URLs as column data.? Perhaps there are still some benefits
that I never learned, as I did not investigate them too much further.

Regards, Chuck

On 08 May 2012 14:48, Gqcy wrote:
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:

I think perhaps you should look at datalinks...

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


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].