Previous Topic: -111 - THE VIEW IS NOT UPDATABLE BECAUSE IT CONTAINS A SUBQUERYNext Topic: -117 - RAAT/CBS ERROR: CMD=xxxxx TBL=ttt DBID=nnnn KEY=kkkkk RC=rr (iii)

SQL Codes › SQL Return Codes -1 through -999 › -113 - THE VIEW'S COLUMN IS NOT UPDATABLE: aaaa

-113 - THE VIEW'S COLUMN IS NOT UPDATABLE: aaaa

Reason:

You attempted an INSERT or an UPDATE using a column (aaaa) of a view that is not updatable. Columns are not updatable if they are expressions or functions.

The SQLSTATE that equates to this SQL return code is 42808.

Action:

Let the value for the column default or use the base table to do the INSERT or UPDATE.