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