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
 

 

Can we upadte view?

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

New User


Joined: 21 Oct 2003
Posts: 45

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

mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1203
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
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 Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts how to find clist's or view library Andrew Hsia CLIST & REXX 4 Tue Jun 28, 2016 6:07 pm
No new posts Report view in Mobile devices Robert Sample All Other Mainframe Topics 0 Thu Jun 23, 2016 7:05 pm
No new posts COBOL Report view in Mobile devices balaji81_k COBOL Programming 4 Thu Jun 23, 2016 6:41 pm
No new posts View Copybook having COPY statement i... nkumar Compuware & Other Tools 6 Mon May 16, 2016 7:28 pm


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