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 12:27 PM
> To: Java Programming on and around the iSeries / AS400
> Subject: Re: resultset has all columns names in upper case
>
> Hi
> SELECT TEST as "mytest" from TABLE1 worked,
>
> This is very strange, is it regular SQL behaviour or some 
> thing with java,
> or db2, or jt400
>
> Ashish
> -- 

It is what I am used to in my SQL. From what I've read on the web, the ANSI standard (which I cannot afford to buy, it ain't free) says that unquoted column names are to be folded into UPPERCASE.

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