[rm-users] Re: RMScript and large reports

[Nathan Stratton Treadway]

On Tue, Aug 31, 1999 at 11:12:14AM -0400, Laverdiere, Rebecca wrote:
> We are trying to put large mainframe reports into WebSqribe for viewing.  We
> are taking the approach of putting the report through an sqr program to get
> rid of carriage control characters and breaking the report into smaller
> reports based on the data (the end reports are .lis files).  We then use
> RMScript to 'put' the report into ReportMart.  The problem is that several
> of the reports are still very large and so we would like to burst them (we
> use the burst option on several sqr queries that we have published through
> RMAdministrator when due to the large number of pages, it just takes way too
> long to retrieve).  We have been told that there isn't such an option in
> RMScript.  Does anyone know of a better way to get these out there?

It sounds like you are trying to do "on demand paging" of one virtual
document within ReportMart, right?  In other words, you've already split
the report as much as possible based on the content into separate files
that are loaded into ReportMart as separate objects, and now you're
trying to use the equivalent of SQR's -burst:p... option to
reduce the size of the file being downloaded without actually changing
the view the user gets on the WebSQRIBE page.

If all this is correct, then I'm afraid there is no easy answer.  As you
say, RMScript just doesn't have the flexibility to do this.

I have faced this problem at one site, but the solution we found
involves using a Java program to call the RM/API and "trick" it into
using -burst:p during the load.  We were already using Java to do our
loading so that wasn't a huge problem for us (it might be for you), but
using the "trick" slows down the load time somewhat because it actually
involves processing the incoming SPF file twice (once the normal way,
the second time using -burst:p...).

If you are interested in pursuing this approach and no other workarounds
are suggested here, let me know and I'll dig up the section of code that
handles this.

						Nathan
----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/