Re: Storing flst files in the database

[Bill Scollard <bill_scollard@TRANSCANADA.COM>]

We follow the approach you are trying to arrive at. Our reports can be stored in a Sybase data base (text table field). Retrieval is like "lightning". Disk usage for the data base IS extensive...but
space is cheap. Sun-unix environment.

"Mani, Bharati" wrote:
>
> > 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

--
Bill Scollard
System Integrator
Gas Industry Systems FST
TransCanada
Loc 2414 TransCanada Tower(East)
(403) 267 - 6379