topic Re: Updating view in Application Development and Automation Discussions

Updating view

Former Member — Fri, 16 Jan 2009 10:32:20 GMT

Hi All,

I have one requirement, such as I have created one ztable and a projection view for that table.

now the data is being pulled from the other system by estabilishing the DBlink...

now that table has been dropped so now if I want to get the data means i need to get it from the ZVIEW.

I am able to do it, now after processing the data there i need to update one field in the ZVIEW.for that i have written one update statement, it is going to dump.

Now what shall I do to update the field in that view.

Regards.

Re: Updating view

Former Member — Fri, 16 Jan 2009 10:50:07 GMT

The View is only a structure an you cannot update or retrieve data from it.

regards,

Jinson

Re: Updating view

Former Member — Fri, 16 Jan 2009 10:53:33 GMT

A view is usually associated with the table and doesn't store any data or information about the tables. So if there is any change, you must create a new view and use it.

Hope this helps

Regards,

Jayanthi.K

Edited by: Jayanthi K on Jan 16, 2009 11:53 AM

Re: Updating view

Former Member — Fri, 16 Jan 2009 10:57:30 GMT

hi,

If the data in a table change, the data in the view is automatically updated by the system

you need to do nothing....view is a run time entity and it will show updated entries only.

thanks

Re: Updating view

Former Member — Fri, 16 Jan 2009 11:02:03 GMT

Hi,

Thank you all,

I know view is a runtime entity and if there is any change in the table then automatically those changes will be reflected in the view.

but in my case what happens is Table has been dropped so i cant update record in the table, so i need to update it through projection view. I think we can update projection view becase it is created on one table.

Does any body knows how to update the projection view........

Regards.

Re: Updating view

Former Member — Fri, 16 Jan 2009 11:10:27 GMT

Hello,

If your table is dropped ; then what is the meaning of View created on this table.

Please do the consitency check of this view and activate it again .

You can use view only if corresponding table exists .

You can modify the table through your view if you have maintained the maintenance status properly.

Regards,

Tushar

Re: Updating view

Former Member — Fri, 16 Jan 2009 11:12:14 GMT

There is no point in having that view when the table is DROPPED.

Create the table again and insert your records into that table.

regards,

Jinson

Re: Updating view

Former Member — Fri, 16 Jan 2009 12:04:48 GMT

Like I mentioned before, you have to create a new view if your table is deleted.

Regards,

Jayanthi.K