× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Giuseppe also has SQL2CSV and SQL2XML.

https://www.mcpressonline.com/programming/sql/techtip-sql2csv-and-sql2xml

Actually, there are several versions of SQL2CSV (google SQL2CSV) out there, one for .net, another written in python.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx /


On 2/28/2024 7:50 AM, Greg Wilburn wrote:
I'll vote for that...

I have used something called SQL2XLS (now SQL2XLSX) for probably 20 years (from Giuseppe Costagliola)
It allows you to do that (and other things). It just doesn't do CSV.

Greg

-----Original Message-----
From: MIDRANGE-L<midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bryan Dietz
Sent: Wednesday, February 28, 2024 10:16 AM
To:midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: systools.generate_spreadsheet

maybe this would be good to vote on:
"Using SYSTOOLS.GENERATE_SPREADSHEET to export data to excel, using an existing excel template."
https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3911

Bryan

Greg Wilburn wrote on 2/28/2024 8:57 AM:
Thanks Gerald... I have it working in an RPG program (but I'm calling it).
I did not test this running under a standard user profile... I may run into issues given our exit point security software.

I think it's a nice addition to my toolbag, but... you lose a lot of granularities.
I have many RPG programs that use IFS tools I created to write data "row-by-row". Like you said, I can control the "column headers", delimiter, etc.
--
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 athttps://archive.midrange.com/midrange-l.

Please contactsupport@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.