Re: JDBC Meta Data

["Richard Dettinger" <cujo@xxxxxxxxxx>]

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.