updating the code of a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dansalmada@gmail.com - 01 Feb 2006 00:12 GMT

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

Reply to this Message

Mark A - 01 Feb 2006 02:44 GMT

> hi
>
[quoted text clipped - 4 lines]
>
> Please help

You need to drop and (re)-create the view.

Reply to this Message

Serge Rielau - 01 Feb 2006 02:46 GMT

> 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

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

Reply to this Message