I have a Linoma GoAnywhere project that I can generically pass a PF name to and it will populate a CSV file and, using SYSCOLUMNS, add a header row that is very descriptive.

But, the CSV format has its' own issues that SQL Workbench seems to overcome with save as XLS.

Linoma has XLS output but, depending on the # of records, the performance is not so hot.

May just need some scripting or such on the SQL Workbench side.



-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Tuesday, October 27, 2015 11:05 AM
To: Midrange-L Midrange-l
Subject: Re: Column titles/text with SQL WorkBench

Hmmm - that’s an issue I have too.

I had thought about trying to come up with something using the sys tables but my SQL is not good enough for that kind of fancy stuff - although I can do it using a separate SQL statement in my Open Access handlers so I guess that will probably do.


On Oct 27, 2015, at 1:14 PM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:

Your not alone. I have yet to figure out how to enable that feature in IBM's own Data Studio product.

Matt

-----Original Message-----
From: Roger Harman [mailto:roger.harman@xxxxxxxxxxx]
Sent: Tuesday, October 27, 2015 11:02 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Column titles/text with SQL WorkBench

I'm using SQL Workbench for a number of data extractions where I need to save the results as XLS.
I haven't found a way to get the column text or titles in lieu of the column names. Does anyone know a way to do this?
Thanks.Roger HarmanCOMMON Certified Application Developer - ILE RPG on IBM i on PowerOCEAN User Group
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.


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


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

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



This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2019 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].