469,306 Members | 1,791 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,306 developers. It's quick & easy.

updating the code of a query

hi

I need to UPDATE or DELETE a view (query) that is on the server

But the UPDATE needs to be made to the CODE of the view and not to the
data it returns.

Please help

Feb 1 '06 #1
2 1005
<da********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
hi

I need to UPDATE or DELETE a view (query) that is on the server

But the UPDATE needs to be made to the CODE of the view and not to the
data it returns.

Please help


You need to drop and (re)-create the view.
Feb 1 '06 #2
da********@gmail.com wrote:
I need to UPDATE or DELETE a view (query) that is on the server

But the UPDATE needs to be made to the CODE of the view and not to the
data it returns.

Can you provide an example?
Note that DATA gets UPDATEd or DELETEd.
Objects get DROPped, CREATEd or ALTERed

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Feb 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Jason | last post: by
reply views Thread by Bob Kaku | last post: by
2 posts views Thread by Ray Holtz | last post: by
3 posts views Thread by Jon Agiato | last post: by
1 post views Thread by cover | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.