Re: Create View

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Fulvio

In the 7.4 SQL Reference I found this statement - it seems there is a way.

Read-only views: The addition of an INSTEAD OF trigger for a view 
affects the read-only characteristic
of the view. If a read-only view has a dependency relationship with an 
INSTEAD OF trigger, the type of
operation that is defined for the INSTEAD OF trigger defines whether the 
view is deletable, insertable, or
updatable.

I did not look up anything about INSTEAD OF triggers, that should also 
be in the SQL Reference.

I hope this helps.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.V2JCxQoO.u6YrRyPI@centurylink.net> CAAC 
(COMMON Americas Advisory Council) IBM Influencer 2023

On 4/2/2025 7:33 AM, Fulvio Biagini - Gmail wrote:
> Hello is there a way to create a view on a physical file that is not 
> updatable but only readable? Grazie!!! Fulvio