Re: Field / Column Name Case

[Charles Wilt <charles.wilt@xxxxxxxxx>]

If you want case sensitive columns names, then when creating teh table they
have to be quoted

create table mytbl (
  "MyColumn" char(25)
);

select mycolumn from mytbl;
Column or global variable MYCOLUMN not found.

select "MyColumn" from mytbl;
SELECT statement run complete.

Oracle works the same way.  Not surprising; given that this follows the SQL
standards...
http://www.alberton.info/dbms_identifiers_and_case_sensitivity.html


Charles

On Tue, Dec 22, 2015 at 11:52 PM, Rob <rob.couch@xxxxxxxxxxxxxx> wrote:

> My script creates the tables using Upper And Lower Case letters.
>
> I can run sql queries using any case.
>
> Why can the all powerful DB2 not return the field names as I created them
> in the result set?
>
> All Caps is for dead head screamers.  This is a new age of computing... we
> have a SHIFT key!
>
> Took me a few minutes to figure out why I was not getting any data out of
> a specific field.  I used fetch_assoc and $aRow[ 'Name' ] rather than
> $aRow[ 'NAME' ] .
>
> I thought that 'i5_naming' => DB2_I5_NAMING_OFF was supposed to turn that
> off.
>
> This is probably just a rant with no solution.
>
> --
> Your Out-Source IT Department,
> Rob Couch
> IT Serenity
> 214 682 7638
> Skype: itserenity
>
> --
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
> list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.