DB2 SQL View Editable Fields

[evr72]

Hello,

I am a bit new at this one. I have a table for orders, each order has a unique number lets call it "UORD"
I create a view with just the "UORD" field, is there a way to create a view and add fields to the view that can be edited?
I tried the example below but it did not work, I got a non editable record error

create view ordreasons as select uord, (case when uord<>'' then '     ' end)as reasoncd from orders

I am trying to build a table for every existing open order and add a field for the reason the order has been put on hold

any help is much appreciated.

thanks