Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Why do we use Aliases and Synonyms in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Mon Apr 02, 2007 11:09 am    Post subject: Why do we use Aliases and Synonyms in DB2
Reply with quote

Why do we use Aliases and Synonyms in DB2???
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Apr 02, 2007 11:36 am    Post subject:
Reply with quote

Hi There,

Please refer the below link

http://www.ibmmainframes.com/viewtopic.php?t=13674&highlight=aliases+synonyms
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Mon Apr 02, 2007 12:07 pm    Post subject: Re: Why do we use Aliases and Synonyms in DB2
Reply with quote

Those links doesn't give you a clear idea.
Could you please explain the actual use of it.
Back to top
View user's profile Send private message
Ranjanapai

New User


Joined: 21 Mar 2007
Posts: 3
Location: India

PostPosted: Tue Apr 03, 2007 3:38 pm    Post subject:
Reply with quote

Aliases and synonyms are alternate names given the data base object. Using these will ease programming because since we are not hardcoding the table names with full qualifiers in the query, it becomes simple to use the code in different regions like testing, development production etc...


Synonyms can be created only on existing objects and they get deleted when the object is deleted.

alias can b created even if the object is not available and remains even if the object is deleted.

Hope this helps...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISPF 3.4, SF line command does not su... Pedro TSO/ISPF 0 Fri Jan 15, 2016 11:09 pm
No new posts Whats the difference between alias an... jose.jeyan Mainframe Interview Questions 5 Wed Sep 06, 2006 5:11 pm
No new posts can we create view to synonyms plz g... kiran.v2 DB2 1 Mon Oct 10, 2005 10:59 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us