Modifying Data Through Views

Usage information for modifying data through views.

  • delete statements are not allowed on multitable views.

  • insert statements are not allowed unless all not null columns in the underlying table or view are included in the view through which you are inserting new rows. The SAP ASE server cannot supply values for not null columns in the underlying table or view.

  • You cannot insert directly to a computed column through a view. The value of computed columns can only be generated internally by the SAP ASE server.

  • insert statements are not allowed on join views created with distinct or with check option.

  • update statements are allowed on join views with check option. The update fails if any of the affected columns appear in the where clause, in an expression that includes columns from more than one table.

  • If you insert or update a row through a join view, all affected columns must belong to the same base table.

  • You cannot update or insert into a view defined with the distinct clause.

  • Data update statements cannot change any column in a view that is a computation, and cannot change a view that includes aggregates.