Page 1 of 1

DB2 - ALIAS use in Production

Posted: Mon Aug 24, 2009 3:36 pm
by biswaranjan
Hi,

Where exactly is alias used in our day to day life and its advantages. Why to use ALIAS in Production or during implementation?

Also...if suppose there is a table EMP, i create two alias for it based on authorization id.....
1.A.TEXAS.EMP
2.A.NEWJERSY.EMP

Both point to EMP....now if TEXAS deletes the row from ALIAS will those rows be actually deleted from EMP? Will those rows still be accessible from NEWJERSY.

Thanks,
Biswa.

Posted: Fri Aug 28, 2009 9:36 am
by Anuj Dhawan
Though you don't ask about synonyms but referring them here would help, probably.
  • Aliases can refer to local or remote sites while synonyms only to the same sub-system
  • synonyms are not allowed to be qualified
  • alias can be referenced by several users, sys. only by the owner

Posted: Fri Aug 28, 2009 9:40 am
by Anuj Dhawan
You may read through this page from IBM Creating an alias.