Ansicht
Dokumentation

SQL0511 - FOR UPDATE clause not valid. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   BAL Application Log Documentation  
This documentation is copyright by IBM.


Message : SQL0511
FOR UPDATE clause not valid.

Message Long Text :

Cause . . . . . : The FOR UPDATE clause cannot be used for cursor &1 because the result table is read only. The result table is read only if:
-- The select-statement includes the DISTINCT keyword, an aggregate function, a GROUP BY clause, a HAVING clause, or a UNION, EXCEPT, or INTERSECT operator.
-- The select-statement contains a VALUES clause.
-- The FROM clause identifies more than one table, more than one view, or a read-only view.
-- The FROM clause contains a data change table reference.
Recovery . . . : Cursor &1 cannot be updated. Remove the FOR UPDATE clause.

Message File : QSQLMSG
Library Message File : QSYS2924


TXBHW - Original Tax Base Amount in Local Currency   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3218 Date: 20240419 Time: 223710     sap01-206 ( 3 ms )