geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JohnSimpson <>
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;
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?



View this message in context:
Sent from the Apache Geronimo - Users mailing list archive at

View raw message