RE: JDBC Meta Data -- JAVA400-L

The table I am looking at has the label and comment set. When I look in
QSYS2/SYSCOLUMNS I can see (And I set it when creating the table).

Using the Toolbox JDBC driver I am not able to see it. Is there something
special that I need to do with Toolbox JDBC driver to return the values?
Which method of the Meta Data will return the text for either one of the
descriptive attributes?

Etienne

-----Original Message-----
From: Richard Dettinger [mailto:cujo@us.ibm.com]
Sent: Wednesday, February 13, 2002 3:06 PM
To: java400-l@midrange.com
Subject: Re: JDBC Meta Data



I'm not an expert on exactly how the internals of this work but here is
what I know about the subject.

There are two ways to give columns names in SQL (which match to some aspect
of DDS that I know nothing about).  Here are two examples;

LABEL ON COLUMN CollectionName.tableName (columnName text is 'descriptive
entry')

COMMENT ON COLUMN CollectionName.tableName (columnName IS 'descriptive
entry')

The Native JDBC driver can only see entries from teh COMMENT ON command.  I
don't know exactly where the LABEL ON entries end up, but they don't get
returned from the database through the CLI.  I believe the Toolbox JDBC
driver can see either one.

Richard D. Dettinger
AS/400 Java Data Access Team

Democracy's enemies have always underestimated the courage of the American
people.
It was true at Concord Bridge.  It was true at Pearl Harbor.  And it was
true today.

         Rochester Post-Bulletin
         Tuesday September 11, 2001


|---------+----------------------------->
|         |           "Richards, Etienne|
|         |           (CAP, PTL)"       |
|         |           <Etienne.Richards@|
|         |           penske.com>       |
|         |           Sent by:          |
|         |           java400-l-admin@mi|
|         |           drange.com        |
|         |                             |
|         |                             |
|         |           02/13/2002 01:51  |
|         |           PM                |
|         |           Please respond to |
|         |           java400-l         |
|         |                             |
|---------+----------------------------->

>---------------------------------------------------------------------------
-------------------------------------------------|
  |
|
  |       To:       "'java400-l@midrange.com'" <java400-l@midrange.com>
|
  |       cc:
|
  |       Subject:  JDBC Meta Data
|
  |
|
  |
|

>---------------------------------------------------------------------------
-------------------------------------------------|



All,

We have column labels defined for the columns in a DB/400 table. When
running a query from STRSQL we see the nice long descriptions of the
columns. I have not been able to receive the same information using JDBC
ResultSet MetaData.

Is it possible to retrieve this data?

Etienne Richards
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.





_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.