RE: resultset has all columns names in upper case

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