Re: Storing flst files in the database

[the dragon <ceprn@HOTMAIL.COM>]

Adam, Mani,

This would work, but you are going to take up an aweful lot of hard drive
space - and that would be subject to hard drive failure, or even worse,
manual or automated cleanup of old files.

Depending on how long it takes to create the reports, why not save the
parameters for the report in a table and then just recreate the reports as
needed rather than saving globs of output that you may or may not ever need
again - I mean, 80k x 12 x 12 = 11,520,000 reports a year hanging around...
even if each report only uses 1000 characters, that's 11.g gig of hard drive
dedicated to these reports - doesn't sound like the best plan to me, and
sounds extremely difficult to maintain.

And, I agree, storing the text of the report would be silly.

clark
dragon enterprises, consulting services.

----Original Message Follows----

I can probably help you with this.  I probably should, seeing that we're
partners (PHH / WEX). ;)

Assuming you're naming each report uniquely, can't you just insert the name
of the report file (*.lis or *.spf) into your report table?

If you store the text of the report in a huge field, you'd have to extract
it, write it out to a file, then reprint the file.  I think it'd be better
to keep the file stored on UNIX, which is more efficient at file handling
than Oracle.

Let me know and we can arrange a call or more email.

 > -----Original Message-----
 >
Hi
We have Oracle 7.3 on HP Unix . The reporting system that we have is
developed using SQR v3.0. We basically do cycle reporting and have around 12
cycles in a month. Each time a cycle runs a huge number of reports is
generated (around 80,000).  These reports are stored in an unix directory.
My question is How do I store these reports in a table so that later on when
I want to do a reprint I just go to the table get the corresponding report
and print it out.

Can I have a table that has a long raw field in which I store the reports.
Any inputs on this is greatly appreciated
Thanks
Bharathi

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com