RE: resultset has all columns names in upper case

["McKown, John" <John.McKown@xxxxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
> Sent: Thursday, February 04, 2010 10:56 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: resultset has all columns names in upper case
>
> Hi
> When i run a query
>
> SELECT TEST as mytest from TABLE1, i am expecting my 
> resultset should have
> column name as mytest,
>
> But my resultset has column name as MYTEST, all upper case
> I am using jt400 JDBC driver, is there any setting in JDBC 
> properties any
> ideas
>
> -- 
> Ashish

Have you tried:

SELECT TEST as "mytest" from TABLE1

? SQL normally uppercases(?) the names, unless enclosed in " marks.

--
John McKown 
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john.mckown@xxxxxxxxxxxxxxxxx * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM