View Alter Option

The Alter View option permits changes to any characteristic of a view. DB2 does not provide an ALTER VIEW statement, so the view is dropped and re-created. The screen flow for an Alter session is similar to the Template session.
carcudb2
The Alter View option permits changes to any characteristic of a view. DB2 does not provide an ALTER VIEW statement, so the view is dropped and re-created. The screen flow for an Alter session is similar to the Template session.
The View Alter screen is similar to the View Template screen. When the screen appears, all columns from every table referenced are displayed in the column scrollable area. Change fields as necessary, according to the procedure outlined in the Create. When finished, press F3 (End) to process the alter. There is no DB2 ALTER VIEW statement. All view alterations are made by dropping and recreating the view.
Use the ALL command to select all the columns of a table.
The Alter Confirmation screen appears. Accept, edit or reject the DDL to be used to alter the view.