DB2 - ALIAS use in Production

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
biswaranjan
Member
Posts: 20
Joined: Thu Aug 28, 2008 10:41 am

DB2 - ALIAS use in Production

Post by biswaranjan » 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.

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Aug 28, 2009 9:36 am

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
Regards,
Anuj

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Aug 28, 2009 9:40 am

You may read through this page from IBM Creating an alias.
Regards,
Anuj

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others