You can use the ALTER VIEW statement:

    o  In interactive SQL

    o  Embedded in host language programs

    o  As part of a procedure in a SQL module

    o  In dynamic SQL as a statement to be dynamically executed