getColumnLabel of ResultSetMetaData returns only the field name

["Patrick L Archibald" <Patrick.Archibald@xxxxxxxxxxxxx>]

Hi All

I can't get the getColumnLabel from a to work like
I think it should.

After creating the SQL table TRASH/ROOT1 from STRSQL tool,
I've done the following:

label on column trash/root1 (dircname is 'Directory Name')

label on column trash/root1 (dircname text is 'Directory Name')

When I use the getColumnLabel from a ResultSetMetaData in
my servlet I get just the field name DIRCNAME returned.

I'm stumped. Does OS/400 not support this method or? I've
searched the newsgroups using google and found many others
on different systems having trouble with this. Some said
that it only works if you specify the "AS" in the "SELECT"
statement.  I hope that is not the case.  I'm building
HTML tables dynamically on any file.  I would like
to use the column heading or label in the <TH> tags.

Specs: OS/400 V4R5M0 620-2175-832MB WAS 3.5.3 JDK 1.2

BTW, have y'all noticed the changes recently
to the newsgroup search function at http://www.google.com?

Thanx, PLA
/
/ Patrick L Archibald
/ http://HomeTelco.com/pla/
/