Kbase P12381: Use set schema statement to define 'PUB' as default owner of referenced database objects
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to access SQL-92 database tables without the pub prefix
FIX:
Use the following SQL statement:
SET SCHEMA 'pub'; commit;
This command will allow the current session to alway use pub as the default owner for any table/object being referenced. Any database object being accessed that is not owned by pub will have to have it's owner specified.