RE: Store file location on IFS in datalink column

Ashish;

There are several set up steps that need to be completed, you can find them in http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/index.jsp under database->SQL Programming->Processing special data types->Using Datalinks->Working with DataLinks

Sorry I couldn't get a book mark to pass along.

You will want to do some future planning. In our case we decided that datalinks will be linked to only one directory tree and only files with links will be written to that tree. If we have a new application that needs links a new directory will be added to the master directory.

Duane Christen



--


Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx

Visit PAETEC.COM


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Monday, October 11, 2010 1:55 PM
To: Midrange Systems Technical Discussion
Subject: Re: Store file location on IFS in datalink column

Hi
Is there any special process we have to run on AS400 to enable datalink, how does database know to watch files in IFS folder?

Ashish

On Mon, Oct 11, 2010 at 2:15 PM, Christen, Duane
<Duane.Christen@xxxxxxxxxx>wrote:

I use datalinks in several applications.

It adds some overhead, the datalink database server, and some coding
rules when creating/retrieving datalinks.

The reason I use it is that you can enforce database record rules on
the linked IFS files.
In one application the IFS files must be kept for 6 months. Burning
them to optical is not feasible because of the volume, and the short
retention period.

The datalink fit our existing process with very few code changes and
we can enforce the retention of the IFS files through the database record.

Duane Christen

--


Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx

Visit PAETEC.COM


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Friday, October 08, 2010 2:25 PM
To: Midrange Systems Technical Discussion
Subject: Store file location on IFS in datalink column

Hi
Has anyone used datalink column to store location of PDF file or any
file on IFS folder of AS400, if yes how,

we have these PDF files which are on IFS folder, so instead of saving
them in database in blob we would like to create a datalink to these
pdf files which we can read and display pdf file using servlet.


--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
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 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.

--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
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.