Re: Column titles/text with SQL WorkBench

Assuming you're using SQL Workbench/J...

Which seems to use JDBC...

Take a look at setting the JDBC connection property, "extended metadata" to
"true"

That's what iNav RunSQL scripts uses to switch between column names (false)
and labels (true)

Charles


On Tue, Oct 27, 2015 at 4:36 PM, Roger Harman <roger.harman@xxxxxxxxxxx>
wrote:

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 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.