× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2010

Re: Store file location on IFS in datalink column

Hi
Thanks for the information and links, basically i am trying to figure out
what is the best way to store PDF files, i have a sample project to save PDF
files as BLOB in DB2, other one was to save PDF files to IFS,
I already have a resteasy service which can read pdf data in blob or from
IFS and convert to byte array and send it to brwoser.

Now i have to do some testing to check the performance, which is more
efficient, how to maintain these PDF, they are all read only. once created
they are not changed,

Check how much hard disk space both option take, and how to do backups etc.

I will check into datalink and configure

Ashish

On Mon, Oct 11, 2010 at 5:42 PM, Vern Hamberg <vhamberg@xxxxxxxxxxx> wrote:

Ashish

I suggest you go to the documentation - this is not a simple topic to be
explained in a couple sentences. Here is a link to the V5R4 version on
Using Datalinks - follow the links inside the article to get more
information.

That article will tell you how to read datalinks and how to get to the
data pointed to by the link. At least, it should, if IBM is being nice
to you!


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

Now Richard suggested you just keep the path in a text column - that's
very simple, easy to maintain, no extra servers and all. You'll have to
figure out what benefit you get from datalinks. You can send the binary
bytes of any IFS file to the browser as it requests it. Don't ask how -
I didn't write that part of our product and haven't had reason to look
at it yet!

Regards
Vern

On 10/11/2010 1:55 PM, Ashish Kulkarni wrote:
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.



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





As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.