Thanks for the tip.  That worked - but what a price!  A simple query went from 10 seconds to 83.

I'll definitely be selective when using it.

Roger Harman
COMMON Certified Application Developer – ILE RPG on IBM i on Power
 
 


Date: Tue, 27 Oct 2015 16:56:34 -0400
Subject: Re: Column titles/text with SQL WorkBench
From: charles.wilt@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx

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.


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

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