MVSFORUMS.com

csk · Beginner Joined: 20 Sep 2006 Posts: 11 Topics: 5

Hi all,

I have a reporting process where in there is a DNS link which would point to a mainframe dataset.
Eg. http://test/'Test.Dataset.file'

where Test.Dataset.File - a dataset which resides in mainframes (CSV format)
By clicking this link, user would be able to view the data from the dataset in an excel format.

We do have a currently working process in REXX which would wrap these dataset contents into excel format file.
But with this, the batch job ran longer and failed because the dataset was huge.. There would be huge huge no. of records that get reported. Hence, Could you please provide any suggestions on how this could be handled?

Thanks in advance.

Regards,
csk

superk · Advanced Joined: 19 Dec 2002 Posts: 684 Topics: 5

semigeezer · Posted: Sat Jan 31, 2009 1:02 am Post subject:

If you must use Rexx, check the program for 1) bad design and 2) poor optimization. Bad design might include redoing things like reading the file many times. Bad optimization is standard programming practices like reducing the number of function calls that always return the same result, getting unnecessary work out of loops, caching the results until the inputs change, and stuff like that. Rexx on MVS is not that fast compared to most other languages so hand optimization is often worthwhile, especially for GGI scripts like this. You might also compile it but that is a waste of time if the program is badly written.
_________________
New members are encouraged to read the How To Ask Questions The Smart Way FAQ at http://www.catb.org/~esr/faqs/smart-questions.html.

callanand · Beginner Joined: 12 Jun 2007 Posts: 23 Topics: 2

How many records are there in the file. Xcel file has the restriction of 65536 rows.

kolusu · Posted: Mon Feb 02, 2009 11:19 am Post subject:

callanand · Beginner Joined: 12 Jun 2007 Posts: 23 Topics: 2

Thanks Kolusu, We are using MS2003 so was not aware of 2007 features. I would say that the removal of size limitation in 2007 would be a great relief as I myself have to send big files in xcel format and everytime when the no of records is more than 65k I had to split the files.
Thanks for the info.

csk · Beginner Joined: 20 Sep 2006 Posts: 11 Topics: 5

Thanks mates.. Am looking at other possible alternatives.. Will keep you updated if we come up with something significant.