View previous topic :: View next topic
|
Author |
Message |
vamseepotti
New User
Joined: 21 Oct 2003 Posts: 45
|
|
|
|
Can we upadte view?
After coding COBOL-CICS-DB2? What we have to do next? |
|
Back to top |
|
|
mcmillan
Site Admin
Joined: 18 May 2003 Posts: 1210 Location: India
|
|
|
|
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 |
|
|
ajaychandra
New User
Joined: 31 Mar 2005 Posts: 16 Location: Bangalore
|
|
|
|
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 |
|
|
|