Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Can we upadte view?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
vamseepotti

New User


Joined: 21 Oct 2003
Posts: 46
PostPosted: Sun Feb 15, 2004 10:01 pm    Post subject: Can we upadte view?
 Reply with quote
Can we upadte view?

After coding COBOL-CICS-DB2? What we have to do next?
Back to top
View user's profile Send private message
References
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 919
Location: India
PostPosted: Sun Feb 15, 2004 10:21 pm    Post subject: VIEW UPDATE
 Reply with quote
Dear,

Yes, you can UPDATE any table thru it's VIEW only if,

Code:
1. View has selected from only one base table

2. The view contains all the non-default column of base table
Back to top
View user's profile Send private message
ajaychandra

New User


Joined: 31 Mar 2005
Posts: 16
Location: Bangalore
PostPosted: Thu Apr 14, 2005 3:13 pm    Post subject:
Reply with quote
Dear Vamsi

Yes Views can be updated if and only if

1) It is from a single table
2) It should be a row-coloum subset of the underlying base table.


If coloum in view has scalar or Aggregate functions, view from a single table also cann't be updated.

Note: Views cannot have order by or group by clause.

Ajay Chandra
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1