Re: SQL Workbench/J and column descriptions -- MIDRANGE-L

Hrrn,

Well I guess the question is does the JDBC driver return all three, and
does it do it in a platform agnostic way. Do you know enough java to write
a console program to do a SELECT with the JDBC driver? Then you could
examine the resultset with a debugger and see what the column properties
are. The author of SQLWorkbench is very accommodating to feature requests
if you do most of the platform specific thinking for him.

Justin

On Thu, Jan 28, 2016 at 12:28 PM Matt Olson <Matt.Olson@xxxxxxxx> wrote:

So turning on "extended metadata" to true does change the behavior. But
then I loose all the column names in the result set.

I want a three row header:

1. Long Names in row one
2. Short names in row two
3. Column description in row three
4. Data proceeds afterwards.

Or at the very least to hover over the column name and see all this data.

Right now if I just turn on the following extended property I get 90%
there:

"metadata source" to 0 I get the column info (we are on V7R1, but
documentation says this is for V6R1 and earlier, I'm guessing a bug here).

Now when I hover over the column name in SQL Workbench I see the good
stuff:

1. Long Name
2. Column data type, length
3. Remarks (column description)

So, I am just missing the short names.

This is good enough though, gets me almost there. I don't care too much
about the shortnames anyways as the long names are much more readable.
However the RPG programmers always use the short names since they have
limited text area to type in on the green screens and don't have
autocomplete there.

-----Original Message-----
From: Justin Dearing [mailto:zippy1981@xxxxxxxxx]
Sent: Thursday, January 28, 2016 11:05 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: SQL Workbench/J and column descriptions

On Thu, Jan 28, 2016 at 11:44 AM Matt Olson <Matt.Olson@xxxxxxxx> wrote:

Still haven't figured out how to have it show the short and long
column names.

Is that old V5R2 reference still valid for the latest JTOpen release?
It seems JTOPEN should publish a list of all extended properties on
the JDBC driver but sadly I can not find it.

Honestly, I just threw in the first link I saw. Starting from the 7.2 docs
fot JTopen (

http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzahh/javadoc/com/ibm/as400/access/AS400JDBCConnection.html?lang=en
)
I found this page

http://www-01.ibm.com/support/knowledgecenter/api/content/nl/en-us/ssw_ibm_i_72/rzahh/javadoc/com/ibm/as400/access/doc-files/JDBCProperties.html

I had the same issue as you a while ago, and made a bunch of noise about
it here and on the google group for SQLWorkbench/J. The next release of
SQWorkbench will lead to my notes being in the manual on the website.

https://github.com/zippy1981/SqlWorkbenchJ/commit/d7ab39c2397339ed4ab6b4c63df334502b134f3e
A SQlWorkbench/J page on the midrange.com wiki would be a good thing. If
you want to stub one out I'll take a look at it. It seems to be very
popular on this list.
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.