On Tue, Apr 30, 2024 at 1:08 PM gio.cot via MIDRANGE-L
<midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
I also find this link https://code.midrange.com/773388240f.html , some one
told that used this source (compiled) also for V7R3 .. do you think i could
try to compile it without problem ??
Not completely sure what you mean by "compiled", but yeah, why not try
running it?
Besides the link provided by Birgitta (which I'll repeat here for convenience):
https://gist.github.com/forstie/cec5b0bf5c0e6983125ae078b0d04b48
there is also
https://gist.github.com/forstie/2deda50658106461f650cd71917feff9
Both of the gists are by Scott Forstie. One or both are essentially
precursors to the GENERATE_SPREADSHEET function, and should work for
anyone with a recent enough ACS. You can see that the thing that is
actually "doing the work" of creating a spreadsheet (in all three
examples - one at code.midrange.com and two at gist.github.com) is
ACS, invoked as a Java command. All the rest is just wrapper for
convenience.
I haven't looked at the code closely enough to see if any of the three
examples is a duplicate of another.
Personally, I think there is relatively minor benefit to all the SQL
stuff which is wrapping the Java command. You can just as easily wrap
the Java command in a CL program, which many people would find easier
and more convenient to use than an SQL function. In general, I am a
big fan of all the stuff IBM is making available via SQL, but in this
particular case, I don't think it's a big win.
If you're not at the necessary PTF level, you definitely don't have to
wait for it to be installed; just go ahead and use one of the three
examples, or make your own.
John Y.
midrange.com
