manipulating schemas 
Author Message
 manipulating schemas

well, i've an applications which creates some tables via ODBC

unfortunately all tables are created with the schema [username]
(eg. 'ADMIN').

any ideas how to tell DB2 to use another schema ? i can NOT
change the application or the table creation process.

bernd

--
class Mandel{public static void main(String a[]){float b,e,r,n,d;int h;
for(e=1.1f;e>-1.2;e-=.1){for(b=-2;b<1;b+=.04){r=n=0;for(h=127;r*r+n*n<4
&&--h>32;){d=r;r=r*r-n*n+b;n=2*d*n+e;}System.out.write(b>0.98?10:h);}}}}
Job im Java-Umfeld ? http://www.***.com/



Sat, 05 Jul 2003 20:18:32 GMT
 manipulating schemas

Hi Bernd,
Without modifying the application, you can set the CURRENTSCHEMA in the
db2cli.ini file. When this keyword is set, the cli driver sends a "SET
CURRENT SCHEMA" statement after a connection. Check out the CLI Guide and
Refr. for details.

Hope this helps,
David.

Quote:

> well, i've an applications which creates some tables via ODBC

> unfortunately all tables are created with the schema [username]
> (eg. 'ADMIN').

> any ideas how to tell DB2 to use another schema ? i can NOT
> change the application or the table creation process.

> bernd

> --
> class Mandel{public static void main(String a[]){float b,e,r,n,d;int h;
> for(e=1.1f;e>-1.2;e-=.1){for(b=-2;b<1;b+=.04){r=n=0;for(h=127;r*r+n*n<4
> &&--h>32;){d=r;r=r*r-n*n+b;n=2*d*n+e;}System.out.write(b>0.98?10:h);}}}}
> Job im Java-Umfeld ? http://www.conacom.de



Sat, 05 Jul 2003 22:13:43 GMT
 manipulating schemas
If all the tables are allready created, can you define aliases on the
tables?

PM

Quote:

> well, i've an applications which creates some tables via ODBC

> unfortunately all tables are created with the schema [username]
> (eg. 'ADMIN').

> any ideas how to tell DB2 to use another schema ? i can NOT
> change the application or the table creation process.

> bernd

> --
> class Mandel{public static void main(String a[]){float b,e,r,n,d;int h;
> for(e=1.1f;e>-1.2;e-=.1){for(b=-2;b<1;b+=.04){r=n=0;for(h=127;r*r+n*n<4
> &&--h>32;){d=r;r=r*r-n*n+b;n=2*d*n+e;}System.out.write(b>0.98?10:h);}}}}
> Job im Java-Umfeld ? http://www.conacom.de



Sun, 06 Jul 2003 04:23:15 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. XML Schemas and mapping schemas

2. Manipulating ADP reports via ASP.net?

3. Manipulating Sql Server Errors In An Access Project

4. Retrieve AD group to manipulate .ADP forms

5. Manipulating VARCHAR field in DB2

6. Manipulating DTS packages from VB

7. Manipulating result set from stored procedure

8. How to manipulate TEXT fields...

9. Manipulate Selcted data after it has been Selected?

10. manipulate data in Oracle?

11. About manipulate data on SQL Server

12. About manipulating data on SQL Server


 
Powered by phpBB® Forum Software