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.
midrange.com
