RE: JDBC Meta Data

[Geert Van Landeghem <gvl@xxxxxxxxxxxxxx>]

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