Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

some doubt in synonym and alias. plz help me.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mijanurit
Currently Banned

New User


Joined: 26 Aug 2005
Posts: 33
Location: bangalore

PostPosted: Sun Jan 01, 2006 11:28 am    Post subject: some doubt in synonym and alias. plz help me.
Reply with quote

hi friends,
i know synonym and alias. if the base table is dropped then synonym also will be dropped automatically.
but for alias if we drop base table, alias will not be dropped automatically.
even in absence of base table we can create the alias.

I don't have preveleage to create synonym and alias that's why i can't be able to try this problem in my system.

In DB2 reference book written by C.J DATE, it is clearly mentioned that " if we drop base table then both synonym and alias will be dropped automatically."

which one is right?
plz clrfy my doubt.

thanks
regards
mijanurit
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Sun Jan 01, 2006 12:51 pm    Post subject: Re: some doubt in synonym and alias. plz help me.
Reply with quote

Dropping a table or view has no effect on its aliases. But dropping a table or view does drop its synonyms.

Regards,

Priyesh.
Back to top
View user's profile Send private message
mijanurit
Currently Banned

New User


Joined: 26 Aug 2005
Posts: 33
Location: bangalore

PostPosted: Sun Jan 01, 2006 9:49 pm    Post subject: Re: some doubt in synonym and alias. plz help me.
Reply with quote

thanks priyes.agarwal for information.

regards
mijanurit
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Doubt in MFS abdulrafi IMS DB/DC 2 Fri Oct 21, 2016 3:09 pm
No new posts Define Alias for multiple Data sets u... sandy98669 JCL & VSAM 4 Fri May 27, 2016 1:07 pm
No new posts Doubt on GETMAIN, FREEMAIN behaviour Arunkumar Chandrasekaran CICS 3 Sun Aug 30, 2015 9:22 pm
No new posts Doubt in using command code O Appu IMS DB/DC 4 Tue Jan 13, 2015 3:14 pm
No new posts Doubt in using command code D and N t... Appu IMS DB/DC 7 Mon Dec 29, 2014 5:52 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us