IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Locks on Views


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Mon Oct 12, 2009 7:17 pm
Reply with quote

Hi,
Can you tell me if locks be obtained on locks?


And, If a table is locked, can we say the dependent view is also locked?


-Thanks,
Rakesh
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Mon Oct 12, 2009 7:45 pm
Reply with quote

Rakesh,

Quote:
Can you tell me if locks be obtained on locks?

Why do you want to lock a lock. Sounds Funny.
Can you explain this statement of your's

Quote:
If a table is locked, can we say the dependent view is also locked?

Yes. View is just a reference, it doesn't materialize any data.

Sushanth
Back to top
View user's profile Send private message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Tue Oct 13, 2009 7:48 am
Reply with quote

I am sorry for the confusion.

My first question was:

Can you tell me if locks be obtained on views?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DB2 Views with Multiple SQL & Col... DB2 8
No new posts Extract data from n DB2 Views automat... All Other Mainframe Topics 5
No new posts Finding locks on z/OS DB2? DB2 2
No new posts Query on system tables to retrieve vi... DB2 3
No new posts Primery Key / foreign key between Views DB2 1
Search our Forums:

Back to Top