Re: Storing flst files in the database

["Dray, Adam" <Adam.Dray@PHH.COM>]

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-----
> From: Mani, Bharati [SMTP:Bharati_Mani@WRIGHTEXPRESS.COM]
> Sent: Tuesday, October 19, 1999 1:04 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Storing flst files in the database
>
> > 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