<div>
Can you please explain what you mean that it is case insensitive *even with quotes*.<br />
<br />
Thanks<br />
nat
</div>


<div>
if you create table with &quot;db2admin&quot;.&quot;myTable&quot;<br />
<br />
you can still access with DB2ADMIN.MYTABLE or db2admin.mytable ....<br />
<br />
although it will display it as db2admin.myTable in control center.
</div>


<div>
How about the flip scenario?<br />
If db2 has it as MYTABLE,<br />
can I do a <br />
&nbsp; &nbsp; &nbsp; select * from &quot;MyTable&quot; ?<br />
nat<br />

</div>


<div>
Anyhow, let me not hold back your earned points.<br />
<br />
Thanks;<br />
nat
</div>


<div>
<div class="content wysiwyg-content">
Hi;<br />
I am transferring data from mysql to db2 using my own java/jdbc program. Working out ok, except for the fact that our apps use mixed-case names for tables and columns. Although my CREATE TABLE commands issued via jdbc uses mixed case for the names, db2 insists on using only upper case. (This also happens from the CLP or DB2CC, but my concern is for it to [also]work via jdbc.)<br />
<br />
Is there a simple setting at the database level to allow mixed case?<br />
<br />
How do I tell db2 NOT to uppercase my table and column names?<br />
<br />
Thanks,<br />
nat
</div>
</div>


Hi;
I am transferring data from mysql to db2 using my own java/jdbc program. Working out ok, except for the fact that our apps use mixed-case names for tables and columns. Although my CREATE TABLE commands issued via jdbc uses mixed case for the names, db2 insists on using only upper case. (This also happens from the CLP or DB2CC, but my concern is for it to [also]work via jdbc.)

Is there a simple setting at the database level to allow mixed case?

How do I tell db2 NOT to uppercase my table and column names?

Thanks,
nat

Can you please explain what you mean that it is case insensitive *even with quotes*.

Thanks
nat

if you create table with &quot;db2admin&quot;.&quot;myTable&quot;

you can still access with DB2ADMIN.MYTABLE or db2admin.mytable ....

although it will display it as db2admin.myTable in control center.

How about the flip scenario?
If db2 has it as MYTABLE,
can I do a 
      select * from &quot;MyTable&quot; ?
nat


Anyhow, let me not hold back your earned points.

Thanks;
nat

howto use mixed case names for tables and columns db2 8.2

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.