Re: Storing flst files in the database

["Lu, Clint" <Clint.Lu@MDMNETWORK.COM>]

Bharati,

Correct me if I am wrong. Sound like you process all cycles job in Unix
server. Based on what we do in our company is we create Unix batch scripts
to process all SQR programs. In Unix scripts before process, we move
previous listing output files to another directory in Unix and compress them
or after that process for printing later on. Hope it help.



---------------------------------------------
Clint Lu
Caremark Rx, Inc.
Phone: 847-559-4717
Fax    : 847-559-4840




-----Original Message-----
From: Mani, Bharati [mailto:Bharati_Mani@WRIGHTEXPRESS.COM]
Sent: Tuesday, October 19, 1999 12: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