geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JohnSimpson <john.a.simp...@bankofamerica.com>
Subject Re: Default datasource schema
Date Thu, 22 Nov 2007 11:47:04 GMT

Hi David,

I am using DB2 version 8.  The way I understand it to work is that the
schema defaults to the user-id unless a schema is specified in the SQL. 
This is done by adding to the table name, that is:

select * from tableName;
becomes:
select * from schemaName.tableName;

If I wanted to override the schemaName on the fly I would do something like:

set current sqlid = schemaName;
select * from tableName;

Does that make sense?

Thanks,

john

-- 
View this message in context: http://www.nabble.com/Default-datasource-schema-tf4844976s134.html#a13895367
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.


Mime
View raw message