Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Updating view

Former Member

‎2009 Jan 16 10:32 AM

0 Likes
1,437

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.

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.

Reply
7 REPLIES 7
Read only

Former Member

‎2009 Jan 16 10:50 AM

0 Likes
1,362

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

regards,

Jinson

Read only

Former Member

‎2009 Jan 16 10:53 AM

0 Likes
1,362

Hi

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

Read only

Former Member

‎2009 Jan 16 10:57 AM

0 Likes
1,362

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

Read only

Former Member
In response to Former Member

‎2009 Jan 16 11:02 AM

0 Likes
1,362

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.

Read only

Former Member
In response to Former Member

‎2009 Jan 16 11:12 AM

0 Likes
1,362

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

Read only

tushar_shukla
Active Participant

‎2009 Jan 16 11:10 AM

0 Likes
1,362

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

Read only

Former Member

‎2009 Jan 16 12:04 PM

0 Likes
1,362

Hi

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

Regards,

Jayanthi.K