DB2 - ALIAS use in Production
Posted: Mon Aug 24, 2009 3:36 pm
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.
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.