Re: SQL - Generate Spreadsheet

For the most part this is for auditors and they will insist on seeing the code that generates the sheet. If I show them RPG in any flavor they will melt faster than the wicked which of the west. SQL and CL are much easier for them to read and for me to explain. (The auditors are not in the US and English is not their primary language).

This is a US based organization I am writing this for.

That all said I agree RPG would be the more robust solution.

To all the rest who ha responded, thank you. I’ll be trying to get this done yet today.


Jim Oberholtzer
Agile Technology Architects

On Jul 3, 2025, at 1:33 AM, Martijn van Breden <m.vanbreden@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hello Jim

Why do you want to do this in CL? Embedded SQL in RPG is much more versatile.


Kind regards,



Martijn van Breden

lead software architect



What I need to do is generate the spreadsheets, I don’t need to consume the file in CL. The CL would only be a wrapper to run all the SQL statements needed. The preferred output would be a spreadsheet in the IFS.

So I’m still not clear on how to build the SQL so it will at least run in ACS.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.