[rm-users] RMScript and large reports

[Daniel Dugal]

Rebecca,
I would highly recommend using lis_to_spf.sqr from Ray Ontko and Co. Here at
AFFINA we use it for exactly this purpose. It has worked extremely well for
us and handles mainframe file conversion to spf, has options for user
defined bursting and is very well documented. Finally, it is issued under
GPL Licensing (GNU Public License) which makes it free to use.

You can get it from the Ontko website here:
http://www.ontko.com/sqr/sqrlib.html

We have actually wrapped lis_to_spf.sqr in another sqr program that first
looks up configuration info (such as bursting parameters) in a database and
then calls lis_to_spf.sqr with the appropriate parameters. The whole process
is scheduled via cron (HPUX) several times per day so that our mainframe
reports are auto-loaded into reportmart.

One final note that I will add is this; In MHO RMScript stinks! It lacks
error checking and other programmatic tools which would make it suitable for
a production environment. I would strongly recommend using Java to do your
loads. In fact, I know of another project by the Ontko group called CHARM -
(Configure, Hack & Alter ReportMart) that can be used for batch loads. I
didn't see this listed on their page but I am certain that it will be soon.
(Again, we use it here and it works great!)

Hope this helps, I can talk to some degree about our process here if you are
interested, just drop me a note.

------------------------------
Daniel F. Dugal, Jr.
Programmer/Analyst
AFFINA - The Customer Relationship Company
Ph: 309.679.4360

> ----------
> From: 	Laverdiere,
> Rebecca[SMTP:Rebecca.Laverdiere@LibertyMutual.com]
> Reply To: 	rm-users@sqrug.com
> Sent: 	Tuesday, August 31, 1999 10:12 AM
> To: 	'rm-users@sqrug.com'
> Cc: 	Driver, Beverly
> Subject: 	[rm-users] RMScript and large reports
> 
> 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?
> Thanks in advance
> Rebecca Laverdiere
> Liberty Mutual Ins Co.
> 1-603-245-3432
> 
> 
> _______________________________________________
> rm-users maillist  -  rm-users@sqrug.com
> http://www.sqrug.com/mailman/listinfo/rm-users
>