title: IBM DB2: how to change a view's structure without deleting it and create it again?
body: <p>IBM DB2: how to change a view's structure without deleting it and create it again?
  "
  I have a view in DB2 IBM i-series and I would need to "update"/change it's "query". The only way I know so far is deleting and building it again but in this case I have another view based on this one and if I delete the first one, the second is deleted to..</p>