| |
- Causa
- THE FOR UPDATE CLAUSE CANNOT BE SPECIFIED BECAUSE THE TABLE DESIGNATED BY THE CURSOR CANNOT BE MODIFIED.
The result table of the SELECT statement cannot be updated.
This can occur if the SELECT specifies more than one table or view in the FROM clause, if the SELECT list contains a built-in function or DISTINCT,
or if the statement contains an ORDER BY or GROUP BY or HAVING clause.
This can also occur if a view is specified in the FROM clause and the view cannot be updated.
- Ação do sistema
- The statement cannot be executed.
The specified cursor remains undefined in the application program.
- Resposta ao Desenvolvedor
- Updates cannot be performed on the result table as it is specified. Refer to Chapter 5 of DB2 SQL Reference
for information about restrictions on the updating of views.
SQLSTATE: 42829
© Copyright IBM Corp.
|
| |
