Re: SQL Workbench/J and column descriptions

Thanks for pointing out that you have to hover to see it - I was wondering where it was supposed to show up.

On Jan 28, 2016, at 12:27 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.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com