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

How many base tables can a view access at a time?
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
vinoth_316

New User


Joined: 20 Jun 2006
Posts: 4
PostPosted: Mon Sep 18, 2006 6:38 pm
 Reply with quote
Hi

How many base tables can a view access at any point of time? Is there any such constraint?
Back to top
View user's profile Send private message
sarunkumaar

New User


Joined: 31 Aug 2006
Posts: 15
Location: Chennai, India
PostPosted: Tue Sep 19, 2006 10:24 am
 Reply with quote
I think there is no restriction in the number of base tables for selecting rows from view. But while updating, inserting or deleting a record thru View it should be created from only one Base table and it should satisfy check constraints if any.
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 Access to non cataloged VSAM file JCL & VSAM 18
No new posts How to access web services/website? Mainframe Interview Questions 4
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
No new posts SET PATH in View DDL DB2 2
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us