Re: Tables in a database
Roger Tomas wrote:
>
> Mark Fisher wrote:
> >
> > Is it possible to have 2 tables of the same name but owned by
> > 2 different users on 1 database?
>
> Only if they are temp tables.
>
> -----------
> Roger Tomas
> AG Communication Systems
I think, that if your database is set to ANSI compliant mode
you should be able to use the same tablename for different users.
The tablename in ANSI compliant mode must be given as USER.TABNAME,
so you can have to different tables named ROGER.MYTABLE and
MARK.MYTABLE
You can change the database to ANSI with ontape command.
REMEMBER, you cannot change an ANSI compliant database to non ANSI.
Another solution might be to use private synonyms. Private synonyms
use the syntax USER.SYNONYM. Private synonyms can be used (also) in
non ANSI databases. Used with views you can get very high flexiblility.
--
best regards
+-------------------------------------------------------------+
| Claus Samuelsen Sysdeco Danmark A/S |
| Project Manager Gydevang 22B |
| email: csa@sysdeco.dk DK-3450 Aller'd |
| phone: +45 4814 3000 Denmark |
+-------------------------------------------------------------+