At 10:15 PM 22/03/2011, gorepj wrote:

>I have created a view which is unexpectedly read-only. It derives from the following SQL.
>
>select *
>from CA01P WHERE TYPE01 = 'RQST' ORDER BY IFLG01
>
>This View is non-updatable
>
>If I remove the ORDER BY Clause it becomes updatable. I can't see in the documentation that having an ORDER BY clause will make a view read-only.

I don't know why it would be updatable, as an ordered set is not a natural set.

ORDER BY in a view is quite a recent addition, too. I wondered if it was an accident! There doesn't seem to be much use for it.

./hb