RE: JDBC Meta Data

["Dave Wall" <dawall@xxxxxxxxxx>]

>> Any idea when the retrieving of column headings will be added to the
Toolbox?

The client support is in JTOpen 3.0, but only when running to servers
running the release after v5r1.  I know it doesn't do you any good now, but
the function is coming.

David Wall
AS/400 Toolbox for Java




                      Geert Van
                      Landeghem                To:       java400-l@midrange.com
                      <gvl@reynderseti.        cc:
                      be>                      Subject:  RE: JDBC Meta Data
                      Sent by:
                      java400-l-admin@m
                      idrange.com


                      02/18/2002 02:52
                      AM
                      Please respond to
                      java400-l





Since this is the only way to retrieve Column headings I used the qadbifld
file in my sql query. It slows down the performance a lot but I'm using
this
in a batch program - generating excel files based on AS400 files - which
means no problem for the moment. (I retrieve the description of all fields
of a file and store them in a hastable)

Any idea when the retrieving of column headings will be added to the
Toolbox?

-----Original Message-----
From: Dave Wall [mailto:dawall@us.ibm.com]
Sent: donderdag 14 februari 2002 20:27
To: java400-l@midrange.com
Subject: RE: JDBC Meta Data



Sorry, I tried several things but cannot get the column label using Toolbox
to a v5r1 or earlier machine via metadata methods.  It does work to a
server running the release after v5r1 because of enhancements to the
server, but that doesn't do you any good.  One thing that does work is
directly querying the syscolumns table.  I was able to get the label using
      "select COLUMN_HEADING from QSYS2/SYSCOLUMNS WHERE TABLE_NAME
= 'COLUMNS'
      and table_schema = 'DAWJDBC' and COLUMN_NAME = 'P1' "
but I don't know if that is a reasonable option for your case.  My concern
is performance.  Will it be fast enough on a big system with lots of
tables?

David Wall
AS/400 Toolbox for Java





Geert Van Landeghem
Reynders Etiketten N.V
*   +32-(0)3/460.32.81
* +32-(0)3/455.18.83
M      +32-0477/75.95.33
*   gvl@reynderseti.be


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