RE: upper/lower case on table and column names

2005-02-11 Thread Dittmar, Daniel
>When creating tables, I've realised that MaxDB has converted >all of my lower >case table and column names to upper case. > >I know that there is a way around this of doing "SELECT field1 >AS 'field1', >field2 AS 'field2' FROM mytable as 'mytable'", but this seems >rather clumsy >and I wondered

AW: upper/lower case on table and column names

2005-02-11 Thread Zabach, Elke
phil benson wrote: > > OS: Redhat Linux 9.1 > MaxDB 7.5 > > When creating tables, I've realised that MaxDB has converted all of my > lower > case table and column names to upper case. > > I know that there is a way around this of doing "SELECT field1 AS > 'field1', > field2 AS 'field2' FROM myta

upper/lower case on table and column names

2005-02-11 Thread phil benson
OS: Redhat Linux 9.1 MaxDB 7.5 When creating tables, I've realised that MaxDB has converted all of my lower case table and column names to upper case. I know that there is a way around this of doing "SELECT field1 AS 'field1', field2 AS 'field2' FROM mytable as 'mytable'", but this seems rather c