Mainframe - I have one view which is derived from the table "A" and table"B". can i delete a row from this view

GeekInterview.com > Interview Questions > Mainframe

Go To First | Previous Question | Next Question

Mainframe | Question 2 of 55

I have one view which is derived from the table "A" and table"B". can i delete a row from this view? and after deleting what will be the data of table A and B?

Total Answers and Comments: 4

Last Update: October 20, 2006 Asked by: sachin

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 19, 2005 09:47:55

Sachidanandan

RE: I have one view which is derived from the table "...

Answer:In complex view we cannot delete the table more than one by using the view concept.

DML operations cannot be done in complex view but it can be deleted by using simple view concept.

Is this answer useful? Yes | No

November 14, 2005 23:52:08

vamsi536

Member Since: November 2005 Contribution: 2

RE: I have one view which is derived from the table "...

Ya It is true that that the DML concepts cannot be used in the complex views such as views containing JOINS. These can be applied to the views which are created on one table with a simple SELECT query.Any changes to this view changes the master table like(ADD DELETE UPDATE)

Is this answer useful? Yes | No

February 18, 2006 05:40:52

pjagannatha032

Member Since: January 2006 Contribution: 3

RE: I have one view which is derived from the table "...

the simple reason to this is DML operations can be done on a single table AND AS YOUR VIEW IS DERIVED FROM MORE THAN ONE TABLE SO IT IS NOT POSSIBLE TO DELETE.

Is this answer useful? Yes | No

October 19, 2006 22:47:13

ofcourseman

Member Since: October 2006 Contribution: 10

RE: I have one view which is derived from the table "...

Yes. You can not delete a row in a view in the case of complex view.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank