Hi,


1. How could i connect to DB2 using schema name as a parameter. kindly provide me examples or relevent links
2. DB2 variables are non-case sensitive. Is there any option to make it case sensitive(like configurable option or installation option)

Thanks,
Sn

do you mean : set current schema xxxxx ??
what would be the purpose ? not qualifying the tablenames ?

Hi,

I want to connect to DB2 database via JDBC, is it possible to connect using schema name.. ie., is there any provisions to provide schema name in the connection parameters.

regards
Sn

Hi,

I tried ur set schema option, it works fine for me.

thanks a lot

cheers
sn

Don't know what you exactly mean with "variables", but if you mean database objects (table, column, ..) names, you can place the names between double quotes "", otherwise DB2 will convert them automatically to UPPERCASE.
create table Schemanm.TestTable1 (
Field1 INT not null);
internally, DB2 will interpret this as:
create table SCHEMANM.TESTTABLE1 (
FIELD1 INT not null);

create table "Schemanm"."TestTable2" (
"Field1" INT not null);
internally, DB2 will interpret this as:
create table Schemanm.TestTable2 (
Field1 INT not null);

SELECT * FROM Schemanm.TestTable1;
SELECT * FROM SchemaNm.TESTTable1;
SELECT * FROM SCHEMANM.TESTTABLE1;
SELECT * FROM "SCHEMANM"."TESTTABLE1";
will all work.

SELECT * FROM Schemanm.TestTable1;
will not work.

Only
SELECT * FROM "Schemanm"."TestTable2";
will work.