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.
